SELECT a.id,a.name,b.content
FROM person as a LEFT JOIN task AS b
ON a.id=b.person_id
ORDER BY a.id

两个表进行左连接，然后按照person表的id排序即可；