how would i merge a column where matches a different column?
You need to apply update with join if you want to update the cust table

update cust c 
join user u on u.customers_firstname = c.customers_firstname
and u.customers_lastname = c.customers_lastname
set c.customers_id = u.customers_id