many rows to 1 string mysql code example

Example: many rows to 1 string mysql

SELECT person_id,
   GROUP_CONCAT(hobbies SEPARATOR ', ')
FROM peoples_hobbies
GROUP BY person_id;