SELECT paises.pais, paises.pais_code, (SELECT Count(*) FROM usuarios WHERE pais_Id=paises.pais_id) AS Total FROM paises;