Get recursive menu from database

[eluser]mvdg27[/eluser]
Hi guys,

I've been breaking my head all night, on getting a recursive menu from my database! I hope someone can give me some pointers on how I would be able to achieve this.

My database structure is very simple:

id|label|parent

And I'm trying to achieve an array with the following structure as a result of my menu-retrieval function:

Code:

Array
(
    [0] => Array
        (
            [label] => Label 1
        )

    [1] => Array
        (
            [label] => Label 2
            [sub] => Array
                (
                    [0] => Array
                        (
                            [label] => Label 2.1
                            [sub] => Array
                                (
                                    [0] => Array
                                        (
                                            [label] => Label 2.1.1
                                        )

                                )

                        )

                    [1] => Array
                        (
                            [label] => Label 2.2
                        )

                )

        )

    [2] => Array
        (
            [label] => Label 3
        )

    [3] => Array
        (
            [label] => Label 4
        )

)

Hope someone can help me on my way with this one!

Thanks!