group_concat

SELECT a.id,CAST(GROUP_CONCAT(b.status) AS CHAR) status from letter_innermail a LEFT JOIN letter_imail_status b on a.id=b.innermail_id GROUP BY a.id