not in 效率太低
所以用left join来处理
SELECT id FROM `fa_user` AS A LEFT JOIN
(SELECT user_id as i FROM `fa_third`) AS B ON A.id=B.i
WHERE B.i IS NULL
not in 效率太低
所以用left join来处理
SELECT id FROM `fa_user` AS A LEFT JOIN
(SELECT user_id as i FROM `fa_third`) AS B ON A.id=B.i
WHERE B.i IS NULL
还不快抢沙发