sql写删除语句无法运行，报 You can't specify target table 'users' for update in FROM clause 错误的解决办法

报错语句:

delete
from users
where username in (
    select username from users where enabled = 0
)

解决办法:

修改子查询，多嵌套一层

delete
from users
where username in (
    select * from (
    	select username from users where enabled = 0
    ) t
)