SQL for循环使用Select语句中返回的ID

I need to delete a bunch of rows from my database under a certain condition. I have the select statement to return this condition and then for each row in this select statement I need it execute an SP that will delete these rows and a load of related rows. So far I have:I need to delete a bunch of rows from my databa