MySql Database Setup for Hierarchical Locations

Here's the scenario:

I need a database that will hold values in a hierarchical database. So let's say I need to have Alpha - A1 - A45 - "Persons name". And then I also have Beta, Charlie, Delta, ect with the same hierarchy.

What is the best and simplest way to do this? I have looked into other examples for mysql but they seem too complicated for what I need.

Extra Info: This hierarchy needs to be able to be changed on my Web Application. I think a jquery tree would be the best use for this. It would be fantastic if you could help me with an example that can fill the tree with the data and let users change a persons location in the database from the tree.

Any suggestions would help. Thanks!