INSERT INTO `m-auth`.`user_map_system_user`
( `system_code`, `user_id`, `click_number`, `click_time`, `order_sort`, `update_time` ) SELECT
'm-accounting-integration',
t.user_id,
0,
NOW(),
1,
NOW()
FROM
`m-auth`.`user_map_system_user` t
WHERE
t.system_code = 'm-policy-docs'
GROUP BY
t.user_id
表结构: