Menu tree from table (id, parent_id) should use LEFT OUTER JOIN?

[rpmorrow]

Hi,

 

I'm trying to create a menu such as an unordered list based on info in a single SQL table. I've seen examples of using LEFT OUTER JOIN to do it, but this seems to involve multiple tables and I just get an error if I try it with one table. The columns are as follows;

 

id        parent_id          title

1              0          Some words

2              0          Some words2

3              2          Some words3

4              2          Some words4

5              3          Some words5

 

I want it to return the following;

 

Some words

Some words2

    Some words3

          Some words5

    Some words4

 

Can anyone point me to an example?