求教mysql关联查询

[yoyo_]

现有表如下：
table1：


table2：


table2 关联table1的字段sid，请教各位达人，要怎样才能实现如下图所示的效果呢?

[benluobo]

select id,projectid,group_concat(t1.name) from t1,t2 where find_in_set(t1.sid,t2.sid) group by id

[ayayad]

SELECT t2.id,t2.projectid,GROUP_CONCAT(t1.name) AS sname FROM table2 t2 LEFT JOIN table1 t1 ON FIND_IN_SET(t1.sid,t2.sid) GROUP BY t2.id;