inner join

update users as u1
 inner join users as u2
 on u1.id = u2.id
 set u1.mail = concat('test+', u2.id, '@example.com');