sql语法问题

delete from user where id in (select id from order where id = 213)
delete + in 子查询,异常1064 - Child of in predicate should be value
使用delete from user where id in (select id from (select id from order where id = 213) as table)也无法解决,需要怎么改,或者使用什么新的语法

抱歉,delete目前不支持子查询