Hangi Kategoride kaç yazı olduğunu gösterme

function blogCategoryListWidget($explode = array(), $parentId = 0, $categories = NULL) { GLOBAL $dbPdo;
    
    if ( $parentId === 0 ) {
        
        if ( !empty($explode) ) {
            
            if ( is_string($explode) ) $explode = explode(',', $explode);
            
            $rows = $dbPdo->notIn('id', $explode)->orderBy('parent_id', 'ASC', 'parent_order', 'ASC')->select('blog_categories');
            
        } else {
            
            $rows = $dbPdo->orderBy('parent_id', 'ASC', 'parent_order', 'ASC')->select('blog_categories');
            
        }
        
        if ( empty($rows) ) return alertInfo('Kategori bulunamadı');
        
        $categories = array();
        
        foreach ( $rows as $k => $v ) {
            
            $categories[$v->parent_id][] = $v;
            
        }
        
    }
    
    $result = '<ul>';
    
    foreach ( $categories[$parentId] as $category ) {
        
        $result .= '<li>
                        <a href="'.blogCategoryUrl($category->id).'" >'.securityHtml($category->category_title).'</a>';
        
        if ( isset($categories[$category->id]) ) $result .= blogCategoryListWidget($explode, $category->id, $categories);
        
        $result .= '</li>';
        
    }
    
    $result .= '</ul>';
    
    return $result;
    
}

SELECT kategoriler.kategori_ad,
COUNT(*) AS Count
FROM blog LEFT JOIN kategoriler ON (kategoriler.kategori_id = blog.blog_kategori)
GROUP  BY blog.blog_kategori

count($category)