SELECT p.id, p.title, p.content, u.username
FROM posts p
LEFT JOIN users u ON p.author_id = u.id
ORDER BY p.created_at DESC;