Получение количества строк в таблице

<?php
 
 
 
function get_table_category(){
    require_once( $_SERVER['DOCUMENT_ROOT'] . '/shop/config.php' );
$MySql = mysqli_connect($sql_host, $sql_user, $sql_password, $sql_table);
 
$query = mysqli_query($MySql, "SELECT id, name, opis, father, url FROM category LIMIT 10");
 
 
if($query){
echo '<table cellpadding="0" cellspacing="0" border="0" id="table" class="sortable">';
echo '<thead>';
echo '<tr>';
echo '<th><h3>Название</h3></th>';
echo '<th><h3>Описание</h3></th>';
echo '<th><h3>Товаров</h3></th>';
echo '</tr>';
echo '</thead>';
echo '<tbody>';
echo '<tr>';
 
while($table_data = mysqli_fetch_assoc($query)){
 
$query2 = mysqli_query($MySql, "SELECT COUNT(1) FROM product WHERE cat_id = " . $table_data['id']);
$product_count = mysql_fetch_array($query2);
echo '<tr>';
echo '<td>'.$table_data['name'].'</td>';
echo '<td>'.$table_data['opis'].'</td>';
echo '<td>'.$product_count[0].'</td>';
echo '</tr>';
}
echo '</tbody>';
echo '</table>';
}else{
echo 'Категорий не найдено';
}
 
 
}
?>