表一：login
| id | cids | state |
| 1 | 1,2 | 1 |
表二：learn
| id | name |
| 1 | zhangsan |
| 2 | lisi |
| 3 | wangwu |
select g.id, GROUP_CONCAT(s.name) as sname from login g left join tlearn s on FIND_IN_SET(s.id, g.cids) GROUP BY g.id
ziyandeyanhuo 2019-07-01 16:09 原文
表一：login
| id | cids | state |
| 1 | 1,2 | 1 |
表二：learn
| id | name |
| 1 | zhangsan |
| 2 | lisi |
| 3 | wangwu |
select g.id, GROUP_CONCAT(s.name) as sname from login g left join tlearn s on FIND_IN_SET(s.id, g.cids) GROUP BY g.id