mysql 一对多 group查询
标签：
mysql 一对多 group查询
*
FROM
question AS A
JOIN
(SELECT question_id, COUNT(*) AS COUNT FROM visitor GROUP BY question_id) AS C
ON
A.id = C.question_id