mysql sql 查询

[chenjia9695]

主键
Id UId Name seq(排序)
1 1 aa 1
2 1 bb 9
3 3 cc 1
4 2 dd 2
5 1 ee 2
6 1 ff 3

想得到结果
array(
1=>array(aa,ee,ff,bb),
2=>array(dd),
3=>array(ff)
)

seq排序跟UId有关，从小到大，
请问sql语句怎么写

[十一路]

这个是什么结果。。 写一下数据库的返回格式

[嘻哈大咖秀]

select id,Name,group_contact(UID) from catalog group by UID

[码无边]

select UId,group_contact(Name) from catalog group by UID order by seq asc

[ermuzi]

SELECT `uid`, GROUP_CONCAT(`name`) FROM (SELECT * FROM test_a ORDER BY SEQ) as aa group by `uid`