UPDATE unit_info k
INNER JOIN (
SELECT
i.phone,
u.user_name,
i.unit_name,
u.fk_id
FROM
user_info u
INNER JOIN unit_info i ON u.fk_id = i.unit_id
AND i.unit_id = '2895'
AND u.type IN ( 'dw', 'bm' )
) AS j ON k.unit_id = j.fk_id
SET k.phone = 15320322222