-- 查询用户及其订单信息 SELECT u.id, u.name, o.order_id, o.amount, o.created_at FROM users u INNER JOIN orders o ON u.id = o.user_id WHERE o.status = 'completed' ORDER BY o.created_at DESC; -- 查询产品及其分类信息 SELEC