SELECT
c.*,
GROUP_CONCAT( sd.NAME ) AS clientTypeName
FROM
client c
LEFT JOIN sys_dict AS sd ON FIND_IN_SET( sd.id, c.client_type )
WHERE
c.DISABLE = 0
GROUP BY
c.id
字段client
结果
SELECT
c.*,
GROUP_CONCAT( sd.NAME ) AS clientTypeName
FROM
client c
LEFT JOIN sys_dict AS sd ON FIND_IN_SET( sd.id, c.client_type )
WHERE
c.DISABLE = 0
GROUP BY
c.id
字段client
结果