[eluser]davidbehler[/eluser]
As I don't know what your tables look like in detail I would guess something like this should do the trick:
Code:
SELECT category_name, category_id, COUNT(*) AS item_count FROM category left join item on category.category_id = item.item_category_id GROUP BY category_name, category_id ORDER BY category_name ASC;