select t1.uid from (select uid from table1) t1 inner join (select uid from table2) t2 where t1.uid=t2.uid
mysql - join two derived tables
原文：http://www.cnblogs.com/phoenix13suns/p/4948925.html
