CREATE TABLE `personen` (
`person_id` INT NOT NULL AUTO_INCREMENT PRIMARY KEY ,
`name` VARCHAR( 150 ) NOT NULL
) ENGINE = MYISAM
CREATE TABLE `hobbys` (
`hobby_id` INT NOT NULL AUTO_INCREMENT PRIMARY KEY ,
`person_id` INT NOT NULL ,
`hobby` VARCHAR( 150 ) NOT NULL ,
INDEX ( `person_id` )
) ENGINE = MYISAM
INSERT INTO `personen` (`name`) VALUES ('Peter'), ('Paul');
INSERT INTO `hobbys` (`person_id`, `hobby`) VALUES (1, 'Schwimmen'), (1, 'Reiten'), (2, 'Radfahren');
SELECT
p.name
, GROUP_CONCAT(h.hobby SEPARATOR ', ') AS hobbys
FROM
personen p
LEFT JOIN
hobbys h ON h.person_id = p.person_id
GROUP BY
p.person_id;