SELECT z.name AS ziekte, GROUP_CONCAT(s.name) AS "Symptomen"
FROM ziekte z
INNER JOIN koppeling k ON z.id = k.ziekte_id
INNER JOIN symptomen s ON s.id = k.symptoom_id
GROUP BY z.name