UPDATE credit_paymentrecord
SET p.login_username =
SELECT c.login_username
FROM credit_client c, credit_paymentrecord p
WHERE c.id = p.client_id;