MySQL从子查询中的另一个表中获取列的计数

SELECT 
    c.customer_id, 
    c.customer_name, 
    (SELECT COUNT(*) FROM orders o WHERE o.customer_id = c.customer_id) AS order_count
FROM 
    customers c;

SELECT 
    c.customer_id, 
    c.customer_name, 
    COUNT(o.order_id) AS order_count
FROM 
    customers c
LEFT JOIN 
    orders o ON c.customer_id = o.customer_id
GROUP BY 
    c.customer_id, c.customer_name;

CREATE TEMPORARY TABLE temp_order_count AS
SELECT 
    customer_id, 
    COUNT(*) AS order_count
FROM 
    orders
GROUP BY 
    customer_id;

SELECT 
    c.customer_id, 
    c.customer_name, 
    t.order_count
FROM 
    customers c
JOIN 
    temp_order_count t ON c.customer_id = t.customer_id;