SQL语句查询一对多

数据表结构

根据课程表（work_curr）查找教师（sys_user.username),授课教师有多个，一对多查询

查询结果和语句

SELECT cu.* , GROUP_CONCAT(us.username) AS teaName 
FROM work_curr cu JOIN sys_user us 
ON 
FIND_IN_SET 
(us.user_id,cu.teaid) 
GROUP BY cuid