来自两个表的MYSQL请求

Question

May be you can help me:

I have a tables:

1: Users
id   username   email
1    myname     [e-mail]
2    myname2    [e-mail]

2: Accounts
user_id   account
1         37992054
2         3804933 
1         23286966

I need to make a request and get this data:

id   username   email                account
1    myname     [e-mail]    37992054, 23286966
2    myname2    [e-mail]   3804933

Answer 1

You need to join your two tables and use a grouping construct to collapse records with the same user id:

Select u.id, u.username, u.email, group_concat(a.account)
from users as u join accounts as a 
  on a.user_id = u.id
group by u.id;