数据表两层分组拼串

【问题】

I have one table called’activity_data’，table contain following fields

id int(11),
sports_name varchar(20),
activity_date datetime

information ofactivity_datatable

id sports_name activity_date
1 Cricket 2015-05-12
2 Football 2015-05-12
3 Cricket 2015-06-10
4 Basketball 2015-06-08
5 Khokho 2015-06-02
6 Kubbdi 2015-06-04
7 Cricket 2015-05-12
8 Kubbdi 2015-05-12
9 Cricket 2015-06-09
10 Football 2015-06-03

now I’m execute following queries

SELECT GROUP\_CONCAT(id) id ,GROUP\_CONCAT(DISTINCT(sports\_name)) sports\_name,activity_date 
FROM filter\_activity\_data 
WHERE activity_date BETWEEN  '2015-05-12'  AND  '2015-06-04'  
GROUP  BY activity_date 
ORDER  BY activity_date ASC

while executing this:output is getting like this

id  sports_name  activity_date
1,2,7,8  Cricket,Football,Kubbdi 2015-05-12
5  Khokho 2015-06-02
10 Football 2015-06-03
6  Kubbdi 2015-