php - 使用 PHP 对 MySQL 输出进行分组

Question

我有以下数据库表“userdata”

+----+--------+-----------+---------+---------+-----------+
| id |user    |name       | job     | image   |department |
+----+--------+-----------+---------+---------+-----------+ 
|  1 | User1  | name1     |   sales | link1   | sales     |
|  2 | User2  | name2     |   markt | link2   | marktin   |
|  3 | User3  | name3     |   sales | link3   | sales     |
|  4 | User4  | name4     |   sales | link4   | sales     |
|  5 | User5  | name5     |   clark | link5   | admin     |
+----+--------+-----------+---------+---------+-----------+

我想输出结果显示如下：-

Department name : - **Sales**
User1 Image    User3 Image   User4 Image

Name : User 01   Job : Sales
Name : User 03   Job : Sales
Name : User 04   Job : Sales

-----------------------------------

Department name : - **marktin**
User2 Image    

Name : User 02   Job : Sales

-----------------------------------

Department name : - **admin**
User5 Image    

Name : User 05   Job : Sales

在此处输入图像描述

你能帮我如何编写 php 代码吗（我想按部门明智地划分用户组，并在详细信息上方显示用户图像。谢谢

标签： phpmysql