表一 fa_volunteer
image.png
表二 fa_other_config
image.png
sql 根据 fa_volunteer 表service_type_ids 和 fa_other_config 中id字段关联
SELECT
a.*, GROUP_CONCAT(b.title) AS wechatObjectNick
FROM
fa_volunteer a
INNER JOIN fa_other_config b ON FIND_IN_SET(b.id, a.service_type_ids)
GROUP BY
a.id;
