join table to itsself

I am using a table like follows (Just an example):

and this table joins on itsself to get "children" with something like follows:

now the result from that is as follows (column names):
now as you can see the column names are duplicated because it's the same table ... the actual table I am working on has a lot of columns so I don't want to do the following:

is there a way I can add a prefix to all of tablename_one's columns or something like that?

why not have a script generate the SQL?

I can do that ... sounds like it could work, just wondering if there isn't an easier way ...

What is the information you're trying to pull from the table with the query?

it's a left nav ... I'll show you a more relevant example ... the table looks like this:

So let's say the information looks like the following:
navigation

So my menu would look as follows:

with two being a sub of one and the query to pull that from the database would be:

This query would return the following:

so you see that the column names are now duplicated, and obviously while reading through that with a php script I wouldn't be able to specify which Title column I am talking about, so I am wondering, is there a way to give all the columns from the sub_navigation table a prefix without selecting each column "as" ...