SELECT *
FROM users JOIN users_financeiro ON users.idfin = users_financeiro.id

SELECT u.nome, u.endereco, f.numero_fatura
FROM users AS u JOIN users_financeiro AS f ON u.idfin = f.id