Правильный вывод дерева интернет магазина товара и каталогов?

<?php
   $connectBase = mysql_connect("localhost", "****", "*******") or die("Немогу соедениться: " .mysql_error());
   mysql_select_db('*******', $connectBase) or die ('Не могу выбрать БД');

   $q = 'SELECT id, name, path FROM shop_groups WHERE active="1" AND shop_id="5" ORDER BY name';
   $r = mysql_query($q) or die(mysql_error());

   // debug(mysql_fetch_array($r));


   function getModels($groupID, $pathGroup) {
         //по ID группы выводим все товары
         $oCore_DataBase = Core_DataBase::instance()->setQueryType(0)->query('SELECT name, path FROM shop_items WHERE shop_group_id="'.$groupID.'" AND active="1" AND deleted="0" AND shop_group_id NOT LIKE "635" ORDER BY name');
         
      
         while ($row = $oCore_DataBase->asAssoc()->current()) {
            echo '
               <li><a href="/catalog/'.$pathGroup.'/'.$row['path'].'/">'.$row['name'].'</a> </li>
            ';
            // echo '<option value="/catalog/'.$pathGroup.'/'.$row['path'].'/">'.$row['name'].'</option>';
         }
      
   }

   function getGroups() {
         //выводим все активные группы
      $q = 'SELECT id, name, path FROM shop_groups WHERE active="1" AND shop_id="5" ORDER BY name';
      $r = mysql_query($q) or die(mysql_error());

      while ($i = mysql_fetch_array($r)) {
         $id = $i['id'];
         $name = $i['name'];
         $path = $i['path'];

         echo '<li><span>'.$name.'</span>';
         
         echo '<ul>';
            getModels($id, $path);
         echo '</ul>';
         
         
         echo '</li>';
      }
   }





getGroups();
?>

<ul>
   <li><span>AUDI</span>
      <ul>
         <li><a href="#"> Audi A3 (2012-2016)</a></li>
         <li><a href="#">Audi A4 (2008-2015)</a></li>
      </ul>
   </li>
   <li><span>BENTLEY</span>
      <ul>
         <li><a href="#">Bentley Continental Flying Spur (2005-2013)</a></li>
      </ul>
   </li>
</ul>