多表关联查询

SELECT p.id, p.title, u.name AS author, c.name AS category
FROM posts p
INNER JOIN users u ON u.id = p.user_id
LEFT JOIN categories c ON c.id = p.category_id
WHERE p.status = 1
ORDER BY p.id DESC
LIMIT 50;