mysql 查询关系为n 1_按1:n(一对多)关系对记录进行排序

我有两张桌子:

+-----------+ +------------------------------------+--------------+

+ persons | | photos |

+-----------| +---------------------------------------------------+

+ id | name + | id | person_id | path | title |

+-----------+ +---------------------------------------------------+

+ 1 | Tom + | 1 | 2 | ~fred/me.png | Yo, it's Me! |

+ 2 | Fred + | 2 | 2 | ~fred/my_wife.png | I'm Susan |

+ 3 | Jack + | 3 | 1 | ~tom/my_dog.jpg | a woof |

+-----------+ +---------------------------------------------------+

在这种关系中:

个人有许多照片,照片属于个人

我想列出所有有照片的人(即使没有,比如杰克),并按照片的标题排序。

我应该为此编写什么SQL查询(MySQL)?我可以在一对多关系中使用连接吗?

PS:作为一种信息,我希望能够用记录构造这样一个数组:

$persons = Array(

[0] => Array(

[id] => 1,

[name] => 'Tom',

[Photo] => Array(

[0] => Array(

[id] => 3,

[person_id] => 1,

[path] => '~tom/my_dog.jpg',

[title] => 'a woof' // 1st

)

)

),

[1] => Array(

[id] => 2,

[name] => 'Fred',

[Photo] => Array(

[0] => Array(

[id] => 2,

[person_id] => 2,

[path] => '~fred/my_wife.png',

[title] => "I'm Susan" // 2nd

),

[0] => Array(

[id] => 1,

[person_id] => 2,

[path] => '~fred/me.png',

[title] => "Yo, it's Me!" // 3rd

)

)

),

[2] => Array(

[id] => 3,

[name] => 'Jack',

[Photo] => Array()

)

)

多谢!