UltraTree

Features
1) unlimited depth, though you can set a limit
2) makes only one SQL query to draw the tree
3) draws all the ascending branches
4) you can easily add it to your scripts
5) UltraTree generates compact HTML
6) fast - as this static example shows, UltraTree generated a tree with 500 categories with a maximum depth of 14 in 0,6 sec on AMD K6-2 300Mhz with 64MB RAM (Zend 4.0.4 w/o the Optimizer).