Category Tree (Ulimited Sub Categories)

[eluser]bennyhill[/eluser]
I searched the web but couldn't find a concise answer. Has anyone implemented an application that has a category tree where a category can branch and have children? I'm making a product catalog. I need to know how to set up the database tables to support this, and also a recursive function that will query the database.