id拼接保存到单个字段后作为表连接的查询条件
SELECT q.id, concat(q. NAME) qname, d.id did, d. NAME FROM question_po q LEFT JOIN data_configuration d ON q.NAME LIKE concat('%,', d.id, ',%');
SELECT q.id, concat(q. NAME) qname, d.id did, d. NAME FROM question_po q LEFT JOIN data_configuration d ON q.NAME LIKE concat('%,', d.id, ',%');