MySQL - How to concatenate rows into one

Question

I am using MySQL 5.5 and am running a query that returns:

I would like to change it to return:

The SQL is:

SELECT csm_patient_exercise.pat_id, csm_program_exercise.prm_id, mod_name, mod_colour   
FROM csm_patient_exercise, csm_exercise, csm_modality, csm_program_exercise, csm_session_type 
 WHERE csm_patient_exercise.exe_id = csm_exercise.exe_id
     AND csm_exercise.mod_id = csm_modality.mod_id
     AND csm_exercise.exe_id = csm_program_exercise.exe_id
     AND csm_program_exercise.prm_id = csm_session_type.prm_id