Group by Keywords

I have a table with records as follows

CategoryId and KeywordId are coming from two different tables "Categories" and "Keywords" both with columns Id and Name. I want to show group wise count of keywords and their names how can I do it? Please help

expected result