<?php 

        $Query = mysql_query("SELECT alliance, SUM(point) AS Sum_1 FROM table GROUP BY alliance");

        $num = 1;

        

            while($Fetch = mysql_fetch_array($Query)){

            echo $num . ") l'alliance " . $Fetch['alliance'] . " avec " . $Fetch['Sum_1'];

            $num ++ 

            } 

<?php 

"SELECT alliance.id AS id, alliance.alliance_name AS name,



                SUM(users.points) AS points



                FROM alliance



                LEFT JOIN users AS users ON users.alliance_id = alliance.id

                GROUP BY alliance.id



                ORDER BY points DESC" 

<?php 

"SELECT a.id, a.alliance_name AS name, SUM(users.points) AS points

FROM alliance AS a 

LEFT JOIN users AS u ON u.alliance_id = a.id

GROUP BY a.id

ORDER BY points DESC"