Getting group by sum and total sum in a single query

use ROLLUP with your query.

The GROUP BY clause permits a WITH ROLLUP modifier that causes extra rows to be added to the summary output.

SELECT category_id,SUM(price) as totalprice
FROM products 
GROUP BY category_id WITH ROLLUP