mysql )如何使用group by打印，包括count为0时

CREATE TABLE orders (
  id INT,
  product_id INT
);

INSERT INTO orders (id, product_id) VALUES
  (1, 1),
  (2, 1),
  (3, 2),
  (4, 3);

CREATE TABLE products (
  id INT,
  name VARCHAR(50)
);

INSERT INTO products (id, name) VALUES
  (1, 'Product A'),
  (2, 'Product B'),
  (3, 'Product C'),
  (4, 'Product D');

SELECT products.id, products.name, COUNT(orders.id) AS order_count
FROM products
LEFT JOIN orders ON products.id = orders.product_id
GROUP BY products.id, products.name;