在数据库中将两个表的id进行关联

delete from sys_profession_user
where professionID='402880d9152076fb0115210e882c0001'
and userid in
(select userid from view_profession_user
where professionID='402880d9152076fb0115210e882c0001'
and [user] like 'u_%')


INSERT INTO sys_profession_user
           (professionID
           ,userID)
SELECT p.id,u.id FROM sys_profession p,sys_user u;