一对多表结构,查询一的信息的同时统计多的数量 代码: SELECT a.*, count( DISTINCT ( b.sid ) ) AS sycs, count( DISTINCT ( c.sid ) ) AS dycs FROM a LEFT JOIN b ON ( a.sid = b.zyid ) LEFT JOIN zz_zysyjl dyjl ON ( a.sid = c.zyid AND c.sylx = 1 ) GROUP BY a.sid ORDER BY a.pxbj DESC