SQL语句
SELECT
t.id, t.bus_id,
(SELECT group_concat(tb.bus_num)
FROM tra_bus tb
WHERE find_in_set(tb.id,t.bus_id) ) busName
FROM tra_plan t
结果
SQL语句
SELECT
t.id, t.bus_id,
(SELECT group_concat(tb.bus_num)
FROM tra_bus tb
WHERE find_in_set(tb.id,t.bus_id) ) busName
FROM tra_plan t
结果