Displaying categories grouped by parent

Hello!

My site has categories and subcategories. I’d like to create templates for each category and have the subcategories flow in a list on that page.

That is, category A would have it’s own page, and template A would show a list of all the subcategories for category A.

In SQL it would be something like

SELECT * where PARENT = CATEGORY A

Thanks!

T