mysql 查询a表在b表中不存在的记录 select * from tbl_user a where(select count(1) as cnt from tbl_order b where a.phone=b.phone)=0