[Solved] MYSQL Select Query with SUM

Please try this query. I hope it’s will help you.

SELECT catgory_id,COUNT(*) FROM tbl_name GROUP BY catgory_id; 

Thank you!