SELECT
ac.id id,
ifnull( aa.cc, 0 ) count
FROM
activity ac
LEFT JOIN ( SELECT ap.activity_id, count( 1 ) cc FROM activity_apply ap GROUP BY ap.activity_id ) aa ON aa.activity_id = ac.id
mysql下查询
SELECT
ac.id id,
ifnull( aa.cc, 0 ) count
FROM
activity ac
LEFT JOIN ( SELECT ap.activity_id, count( 1 ) cc FROM activity_apply ap GROUP BY ap.activity_id ) aa ON aa.activity_id = ac.id
mysql下查询