-- 查询所有用户及其订单（包括没有订单的用户） SELECT u.id, u.name, u.email, COUNT(o.order_id) AS order_count FROM users u LEFT JOIN orders o ON u.id = o.user_id GROUP BY u.id, u.name, u.email ORDER BY order_count DESC; -