I have a shop that has lots of products in many sub categories...

I want to write a query so that I can have a section on my admin where I can show the stock level in a particular category including all products in following sub categories.

Is this possible?