update shanfangclubdz.cdb_posts a,shanfangclub.uc_members b set a.author=b.username where a.authorid=b.uid