select id from aa where id in ( select id from bb limit 10 );
改写成
SELECT id FROM aa WHERE id IN ( SELECT * FROM (SELECT id FROM bb LIMIT 10) AS ids );