query

SELECT
  *,
  (SELECT json_build_object('id', ref.user_id, 'email', ref.email)
   FROM user_profile_with_referal ref
   WHERE customer_id = 84061) AS referal_info
FROM user_profile_full
WHERE user_id = 84061;