MySQL cannot be modified (you can't specify target table 'basic _ data' for update in from clause)

I encountered a problem today.

You can't specify target table 'basic _ data' for update in from clause

Original sentence

Update basic_data set manage_user = 4 where ID in (select B. ID from basic_data B join Department D on D. id = B. department join users U on u. department_id = D. ID where D. id = 1)

After modification

Update basic_data set manage_user = 4 where ID in (select B. ID from (select * From basic_data) B join Department D on D. id = B. department join users U on u. department_id = D. ID where D. id = 1)

The principle is that MySQL treats the query clause as a temporary table instead of an entity table.