Création d’un tableau HTML avec les donnés d’une requête

select      t1.nom_site   as Site,
                 t2.Nbre_eleve,
                 t2.Eleve_Actif,
                 t2.Eleve_Inactif,
                 t3.Nbre_prof,
                 t4.Nbre_stag

 
           from  site as t1
left outer join  (  select  nom_site,
                            count(id) as Nbre_eleve,
                     sum(case when etat like 'actif'   then 1 else 0 end) as Eleve_Actif,
                            sum(case when etat like 'inactif' then 1 else 0 end) as Eleve_Inactif
                      from  eleve
                  group by  nom_site
                 ) as t2
             on  t2.nom_site = t1.nom_site

left outer join  (  select  nom_site,
                            count(id) as Nbre_prof
                      from  prof
                  group by  nom_site
                 ) as t3
             on  t3.nom_site = t1.nom_site
             
left outer join  (  select  nom_site,
                            count(id) as Nbre_stag
                      from  stage
                  group by  nom_site
                 ) as t4
             on  t4.nom_site = t1.nom_site;