SELECT p.id, p.name, content FROM person p LEFT JOIN task t on p.id = t.person_id ORDER BY p.id asc;