UPDATE sc_face_info f INNER JOIN sc_family_member fm ON f.id fm.face_id SET f.family_member_id fm.id WHERE f.family_member_id IS NULL;