UPDATE 
t_business_opportunity t1,
(select t2.id,t3.user_id from t_business_opportunity t2 left join sys_user t3 on t2.create_by=t3.user_name) as t4
SET t1.create_by = t4.user_id 
where t1.id=t4.id;