将多条数据查询合并成json数组同步

sc_visitor_img表

sc_visitor_stage表

-- 同步阶段图片
update  sc_visitor_stage s,(SELECT JSON_ARRAYAGG(path) as path,m.visitor_id from sc_visitor_img m GROUP BY m.visitor_id)img
   set s.stage_picture=img.path 
WHERE
          img.visitor_id=s.visitor_id;