Alt Katagori çekme sorunu

<li class="menu-item-has-children" ><a href="javascript:void(0)"  title="ÜRÜNLERİMİZ" >ÜRÜNLERİMİZ</a>
                                      <ul class="sub-menu">
                                          <?php 

             $kategorisor=$db->prepare("SELECT * FROM katagoriler where durum=:durum order by id ASC");
             $kategorisor->execute(array(
                'durum' => 1
            ));

             while($kategoricek=$kategorisor->fetch(PDO::FETCH_ASSOC)) { 

                $kategori_id=$kategoricek['id'];
                ?>

                <li><a href="kategoriler-<?=seo($kategoricek['baslik'])."-".$kategoricek['id'] ?>"  title="<?php echo $kategoricek['baslik'] ?>" ><?php echo $kategoricek['baslik'] ?></a>


            
                <?php 

             $query = $db->prepare("select * from altkat inner join katagoriler on  
  
    katagoriler.id = altkat.kat_id where baslik=?
  
  ");
   
   $query->execute(array($link));
   $goster =  $query->fetchAll(PDO::FETCH_ASSOC);
   $x      = $query->rowCount();  
                ?>
                <?php          
           
          foreach($goster as $row){
              
              ?>
              <ul class="sub-menu">
                <li><a href="kategoriler-<?=seo($row['baslik'])."-".$row['id'] ?>"><?php echo $row["baslik"];?></a></li>
            </ul>

            <?php } ?>
                    </li>

                <?php } ?>

<li class="menu-item-has-children" ><a href="javascript:void(0)"  title="ÜRÜNLERİMİZ" >ÜRÜNLERİMİZ</a>
                                      <ul class="sub-menu">
                    <?php $kat=$db->query("SELECT * FROM katagoriler"); 
            while($row=$kat->fetch(PDO::FETCH_ASSOC)) { ?> 
                <li><a href="<?php echo $row['baslik']; ?>"><?php echo $row['baslik']; ?></a> 
                    <?php $altkat=$db->query("SELECT * FROM altkat WHERE kat_id=".$row['id']); ?> 
                    <ul class="sub-menu"> 
                        <?php while($alt=$altkat->fetch(PDO::FETCH_ASSOC)) { ?>
                            <li><a href="<?php echo $alt['baslik']; ?>"><?php echo $alt['baslik']; ?></a></li>
                             
                        </ul> <?php } ?>
                    </li> 
                    <?php } ?>
        
        <li><a href="javascript:void(0)"  title="YEDEK PARÇALAR" >YEDEK PARÇALAR</a></li>
                                    </ul>
                                </li>