card_exhibitor 是展商表
card_card 是名片表
展商表 里之前staff_card 字段存儲(chǔ)的是員工的card id，用逗號(hào)分隔。
后來考慮到 員工card 會(huì)很多，所以設(shè)計(jì)了中間表card_exhibitor_staff_r

將逗號(hào)分隔的數(shù)據(jù)查出來導(dǎo)入到 中間表
sql 如下，備注下，方便以后寫類似語句。

INSERT INTO card.card_exhibitor_staff_r
(id, staff_card_id, exhibitor_id, create_time)
select uuid_short(),cc.id as cardId,ce.id,ce.create_time
from card_exhibitor ce
left join card_card cc on  find_in_set(cc.id,ce.staff_card)
where staff_card != ''
and cc.id is not null;