复杂的问题，高难

Question

table
id        product_name      client    money
21213      电光心            A        25         
14141      电光心            A        100                           
43412      电光心            A        300                                               
41451      光度              B        52
46424      光度              B        12
86534      光度              B        56
97421      光度              B        78
83532      电光心            B        350
83452      电光心            B        310
需要查询结果电光心        21213,14141,43412          A
光度          41451,46424,86534,97421    B
电光心        83532,83452                B

Answer 1

select product_name,client,group_concat(id)
from tt
group by product_name,client