mysql combine many rows one select value code example

Example: mysql concatenate select results

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