update xusers set zongbu = (select zongbu from userinfo where userinfo.gonghao = xusers.gonghao)