PHP/MySQL - 按类别从表值创建 "tree"

Question

在 MySQL 数据库中，我有 3 列:类别、名称和电话。表格看起来像这个例子:

Work       David     777444555
School     Susan     776457333
Work       Peter     743234556
Work       Diana     765432456
Hockey     Ben       786432567
School     Tom       765434566
School     John      765457865
etc...

那么如何使用 PHP 从该表中生成“树”结果(从 A 到 Z 排序)？我需要像这样的例子:

Hockej:
 - Ben, 786432567
 - etc.
School:
 - John, 765457865
 - Susan, 776457333
 - Tom, 765434566
Work:
 - David, 777444555
 - Diana, 765432456
 - Peter, 743234556

Answer 1

SELECT category,
       GROUP_CONCAT(CONCAT(Name, ', ', Phone) ORDER BY Name SEPARATOR ';' ) Names
FROM
    yourtable
GROUP BY category