get product count by category id in woocommerce mysql query code example

Example: mysql show category once count how many products

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