mysql delete 子查询 语法错误

 写了个sql句子，删除具有特殊页面的普通用户的的特殊页面权限

delete from userinfo_m2m_pageinfo as m1 where m1.userinfo_id in 
(select d.id from deploy_users as d,userinfo_m2m_pageinfo as m2 where m2.userinfo_id=d.id and m2.page_id=6 and d.role_id != 1
) and m1.page_id=6

结果一直报语法错误：

查询发现若是delete from表和子查询使用了同一张表就会出错

另外，delete from table 后面的table不能使用别名

delete from userinfo_m2m_pageinfo where page_id=6 and userinfo_id in 
( select id from (select id from deploy_users where role_id != 1) t )