SELECT
    author.author_id AS author_id,
    author.name_last AS name_last,
    author.name_first AS name_first,
    author.detail AS detail
FROM join_play_author
LEFT JOIN author
ON join_play_author.author_id = author.author_id
WHERE join_play_author.play_id = :play_id
ORDER BY author.name_last

Array
(
    [author_id] => 41
    [0] => 41
    [name_last] => Dekker
    [1] => Dekker
    [name_first] => Thomas
    [2] => Thomas
    [detail] => 0
    [3] => 0
)