performance suggestions

Dear group, can someone suggest the best way to do the following without writing some lengthy script that (possibly) could lead to performance issues, I have three DB fields in MySQL, each has a unique ID, I cannot think of any ways other than pulling each tables record then looping through to determine which one each belongs to which group then maybe placing into an array, the association between them all goes like this, URL:- url_id url_name section:- section_id url_id section_name page:- page_id section_id page_name What I need to do is construct a navigation bar with each url, section then pages for that section, is their any quick ways (perhaps with SQL) anyone knows of, A static array im currently using for this looks like:- $nav = array(

    1 => array('title' => "Homepage",
    'url' => "/main::default"),

    2 => array('title' => "About",
    'url' => "/main::about",
            'sub' => array(
                array('title' => "Contact",
                'url' => "/main::about::contact"),
            )
        ),

); Hope that makes sense to someone. Thanks in advance for any suggestions/help James Apache: 1.3.33 PHP: 4.4.1 MySQL: 4.1