update db_operation_log o LEFT JOIN db_user u ON o.user_id = u.id set o.user_name = u.real_name , o.mobile = u.mobile