myscl count products in each category code example

Example: mysql show category once count how many products

SELECT category, COUNT(*) as count FROM table GROUP BY category