思路:左连接,再根据id排序

注意:这里person的id对应task中的person_id

完整代码:

SELECT p.id, p.name, t.content
FROM person AS p LEFT JOIN task AS t
ON p.id = t.person_id
ORDER BY p.id