Users table:
+----------+-----------------+
| user_id | email |
+----------+-----------------+
| user_1 | user1@email.com |
| user_2 | user2@email.com |
| user_3 | user3@email.com |
| user_4 | user4@email.com |
+----------+-----------------+*注意user_3和user_4没有自己的域名
Domains table:
+-----------+------------+
| owner_id | domain |
+-----------+------------+
| user_1 | dom-1.com |
| user_1 | dom-2.com |
| user_2 | dom-3.com |
+------------------------+下表显示了谁是域的用户以及所有者是谁:
User-Domain table:
+----------+-------------+-----------+
| user_id | domain | owner_id |
+------------------------+-----------+
| user_1 | dom-1.com | user_1 |
| user_1 | dom-2.com | user_1 |
| user_2 | dom-3.com | user_2 |
| user_3 | dom-1.com | user_1 |
| user_3 | dom-2.com | user_1 |
| user_4 | dom-1.com | user_1 |
+------------------------+-----------+我的问题是,如何以下列格式输出使用给定用户域的每个用户的列表?
例如(以下是HTML表格):
List of users who are using User_1's domains (HTML TABLE):
+-------------------+-----------------------+
| Email | domains |
+-------------------+-----------------------+
| user3@email.com | dom-1.com, dom-2.com |
| user4@email.com | dom-1.com |
+-------------------+-----------------------+