查询作品对应的评论数量

SELECT a.*,count(b.goods_id) as bnum

FROM ecs_appraise a

LEFT JOIN ecs_appraise_key b ON a.goods_id = b.goods_id AND b.checks=1 

WHERE a.checks=1 

group by a.goods_id order by a.goods_id desc