categories.php

<?php

require_once('DbManager.php');

function getCategories() {

    $query = "SELECT categories.category_id, categories.name, count(products.category_fk) as count FROM categories
                JOIN products ON category_id=category_fk
                GROUP BY products.category_fk";

    return dbGetItemsList($query);

}