mysql 字段多个值逗号隔开如何联查另外一张表

表一 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;