return a subquery as a array/comma seperated list within the row

Hi all

I'm struggling with a MySQL query where I would like to pull back an array of all the peoples ID's that a person has favorited but I keep getting "Error Code: 1242. Subquery returns more than 1 row"

Here's the basic SQL, it grabs the [usr_id] and [usr_username] from the [users] table and then I would like a comma separated list of all that persons [uf_favourited_user_id] from the [user_favourites] table

Example:

SELECT usr_id, usr_username, (SELECT uf_favourited_user_id FROM user_favourites WHERE uf_user_id = 19) AS favourites
FROM users 
ORDER BY usr_date_registered
LIMIT 50

Select allOpen in new window