Group concat

select student_id, group_concat(course_id)
from score
group by student_id

student_id	group_concat(course_id)
1	1
2	1,2
3	1,2,3
4	1,2,3,3
5	1,1
6	2,3