1.设计表单列表
2.添加虚拟字段
, (SELECT GROUP_CONCAT(bb.name_) AS name_ FROM (SELECT DISTINCT substring_index(substring_index(t.F_zdxm, ',', b.help_topic_id + 1), ',', -1) AS zda, t.f_sjzd FROM w_sjzddx t JOIN mysql.help_topic b ON b.help_topic_id < (LENGTH(t.F_zdxm) - LENGTH(REPLACE(t.F_zdxm, ',', '')) + 1)) aa LEFT JOIN portal_sys_dic bb ON aa.zda = bb.key_ WHERE aa.f_sjzd = t.f_sjzd GROUP BY aa.f_sjzd) as name_
注意事项:如虚拟SQL字段查询语句较长,记得为其进行命名哦,并且名称需与显示字段设置的名称保持一致