Update a table with data from another table: truncated incorrect double value mysql
This should do it.  Update your table inner join the second table based on ids.
Then we set the email from one table to the other where the ids are the same.  Hope it helps.

UPDATE tbl1
INNER JOIN tbl2 ON tbl2.user_login = tbl1.user_id
SET tbl1.contact_email = tbl2.user_email ;