如何在SQL中从子查询结果中设置变量1值

I'm not so good with SQL, so help me please. In my stored procedure I'm getting a parameter. Then, based on this parameter I want to get ID from another table and put this ID into my another variable, but the problem is that ID could be multiple based on this parameter.I'm not so good with SQL, so help me please. In