这有效:

SELECT c.id, COUNT(f.name)
FROM color c
LEFT JOIN fruit f ON c.id = f.color_id
GROUP BY c.id

您必须计算一个水果字段，以便可以返回NULL，该值变为零.

You have to count a field of fruit, so that NULL can be returned, which becomes a zero.