คือพอดีจะทำ site map ให้กับเว็บไซต์ครับไม่ทราบว่าการเขียนวนลูปฐานข้อมูลออกมาให้เป็น <ul><li><li><ul> ยังไงครับ

$sql = ตรงนี้ query level 1 เขียนเองนะ
$result = mysql_query($sql);
if(mysql_num_rows($result)>0){

   echo '<ul>';

   while($rows = mysql_fetch_assoc($result)){

   echo '<li>' . $rows['field'] . '</li>';

   $sql2 = ตรงนี้ query level 2 เขียนเองนะ where ด้วย Id level 1
   $result2 = mysql_query($sql2);
   if(mysql_num_rows($result2)>0){

      echo '<ul>';

      while($rows2 = mysql_fetch_assoc($result2)){

      echo '<li>' . $rows2['field'] . '</li>';

      $sql3 = ตรงนี้ query level 3 เขียนเองนะ where ด้วย Id level 2
      $result3 = mysql_query($sql3);
      if(mysql_num_rows($result3)>0){

         echo '<ul>';

         while($rows3 = mysql_fetch_assoc($result3)){

         echo '<li>' . $rows3['field'] . '</li>';

         }

         echo '</ul>';

      }


      }

      echo '</ul>';

   }

}
echo '</ul>';
}

<?php
include "include/connect.php";

$sql = "SELECT *  from tb_type  Order by  id_type asc";
$result=mysql_db_query($dbname,$sql);
if (mysql_num_rows($result)>0){
echo "<ul>";
while($rows = mysql_fetch_assoc($result)){
$id_type=$rows['id_type'];
$name_type=$rows['name_type'];
echo "<li>$name_type </li>";
 
$sql2 = "SELECT *  from tb_subtype   Where ref_id_type='$id_type' ";
$result2=mysql_db_query($dbname,$sql2);
if (mysql_num_rows($result2)>0){
echo "<ul>";
while($rows2 = mysql_fetch_assoc($result2)){
$id_subtype=$rows2['id_subtype'];
$name_subtype=$rows2['name_subtype'];
$ref_id_type=$rows2['ref_id_type'];

echo "<li>$name_subtype </li>";
 
$sql3= "SELECT *  from tb_showbrand where ref_id_type='$id_type' and ref_id_subtype='$id_subtype' ";
$result3=mysql_db_query($dbname,$sql3);

if (mysql_num_rows($result3)>0){
echo "<ul>";
while($rows3 = mysql_fetch_assoc($result3)){
$id_showbrand=$rows3['id_showbrand'];
$name_brand1=$rows3['name_brand1'];

echo "<li>$name_brand1 </li>";
 }
echo "</ul>";
}


}
echo "</ul>";
}
 
 
}
echo "</ul>";
}
?>