Match user and company on multi company odoo environment

select login,res_company.name from res_users JOIN res_company on company_id=res_company.id;