How to group by after mySql query in view page in CI?

I want to group by this results

I have tried so many ways to group by but didnt work. If it is possible to sum the results by group via condition or loop . it will be great. Thanks