一句话就可以完成 insert into rel_friend_dept(owner_id,friend_id,dept_id,mng_self,biz_self,server_flag) select 4,rel_friend_dept.friend_id,tc_department.mng_dept_id,1,1,0 from tc_friend,rel_friend_dept,tc_department WHERE tc_friend.friend_id = rel_friend_dept.friend_id and tc_department.dept_id=rel_friend_dept.dept_id and rel_friend_dept.owner_id = 3 and not exists (select 1 from rel_friend_dept where friend_id = rel_friend_dept.friend_id and dept_id = tc_department.mng_dept_id and owner_id = 3 and dept_id <> 1)
insert into rel_friend_dept(owner_id,friend_id,dept_id,mng_self,biz_self,server_flag)
select 4,rel_friend_dept.friend_id,tc_department.mng_dept_id,1,1,0
from tc_friend,rel_friend_dept,tc_department
WHERE tc_friend.friend_id = rel_friend_dept.friend_id
and tc_department.dept_id=rel_friend_dept.dept_id
and rel_friend_dept.owner_id = 3
and not exists (select 1 from rel_friend_dept
where friend_id = rel_friend_dept.friend_id and dept_id = tc_department.mng_dept_id and owner_id = 3 and dept_id <> 1)