Как организовать сортировку новостей в категории по подкатегориям?

<?php
if( ! defined( 'DATALIFEENGINE' ) ) {
die( "Hacking attempt!" );
}
include ('engine/api/api.class.php');

$tpl->load_template($template);

foreach($cat_info as $k=>$v){
    if($category_id==$v['parentid']){
        $cat_id = $v['id'];
        $sql_select_posts = $db->query( "SELECT p.id, p.autor, p.date, p.short_story, CHAR_LENGTH(p.full_story) as full_story, p.xfields, p.title, p.category, p.alt_name, p.comm_num, p.allow_comm, p.fixed, p.tags, e.news_read, e.allow_rate, e.rating, e.vote_num, e.votes, e.view_edit, e.editdate, e.editor, e.reason FROM " . PREFIX . "_post p LEFT JOIN " . PREFIX . "_post_extras e ON (p.id=e.news_id) WHERE p.category = '".$cat_id."' ORDER by category DESC" );

        $i = 0;
while($row_s = $db->get_row($sql_select_posts)) {
    $i++;
    if( strpos( $tpl->copy_template, "xfvalue" ) !== false OR strpos( $tpl->copy_template, "[xfgiven_" ) !== false ) { $xfound = true; $xfields = xfieldsload();}
    else $xfound = false;
    $full_link = $config['http_home_url'].get_url($row_s['id']).'/';

//Список тегов
$tpl->set('{lastpost-title}', $row_s['title']);
$tpl->set('{lastpost-short}', $row_s['short_story']);
$tpl->set('{lastpost-url}', $full_link.$row_s['id'].'-'.$row_s['alt_name'].'.html');
$tpl->set('{lastpost-date}', $row_s['date']);
$tpl->compile('series');
}
        echo "<h3><a href=\"/".get_url($k)."/\">{$v['name']}</a></h3><br/>\n";
        echo $tpl->result['series'];
    
        }
    
}

$tpl->clear();
$db->free($sql_select_posts);