Here are a couple of options you might use to create a tree view to display your org chart.
not big help.. cftree may not work with what i have...
I would be glad to offer more assistance, however I am not sure what kind of help you need. Your original post contains a query which you state returns the correct data, "this query(field -formated_name) gets all correct levels". You also state you are trying to create a drill down chart, but have not posted any code related to UI. Based on your statement "i was not able to make the visual part" I infered that you'd like a pointer to a resource that will help you create your UI. Can you be more specific about the help you'd like to receive?
applying the cftree to my query outputs what i need...here is how. Thank you all.
<cftree format="html" name="drilldown" width="500">
<!--- <cftreeitem display="#data.formated_name#" value="root"> --->
<cftreeitem display="#first_name# (#employee_title#) →<a href='Evaluation_EditA.cfm?person=#employee_master_uuid#'>Evalution</a>"