更新加子查询加相同的表解决办法 mysql

UPDATE ofuser SET auid = '0' WHERE uid in (SELECT uid FROM (select tmp.* from ofuser tmp)a WHERE auid = '1' and did = '".$_SESSION['did']."')