ALTER table message_session add column group_ids json null;
# 给会话表加上用户组数据。如果数据量过大,可考虑按月分批次执行,在最后的条件里加上创建时间的筛选条件
update message_session m left join (
select ms.chat_id, JSON_ARRAYAGG(ug.group_id) as group_ids from message_session as ms
on ms.user_id = ug.user_id group by ms.chat_id) mg on m.chat_id = mg.chat_id
set m.group_ids = mg.group_ids
where m.group_ids is null;