Mysql query

I need sells from date range 2013-01-01 - 2015-01-01 , group by Category. Trying to create a query that outputs sells by Category, the problem is that the "Sub category 2" was change there' s Parent_Category/parent_id and the results must be on 2 rows for "Product 1". Please, NO PHP only Mysql Please, check attached file.