select * from (
select b.*,(select GROUP_CONCAT(a.realname) from sys_user a where FIND_IN_SET(a.username,b.user_ids) > 0 ) as user_ids_cn from om_repair_order b
) t
mysql逗号分隔的id,翻译出相对应name,支持条件查询
最新推荐文章于 2023-08-12 17:01:57 发布