SELECT a.`name`,IFNULL(COUNT(b.id),0) as total
FROM `meal` a
LEFT JOIN `order` b
on a.id = b.meal_id
GROUP BY a.`name`
SELECT a.`name`,COUNT(a.id) as total,SUM(IF(b.id=6,1,0)) AS '139档5G畅销融合'
FROM `order` a
LEFT JOIN meal b
ON a.meal_id = b.id
GROUP BY a.`name`
-- 如果b.id为6,就加1,否则为0