my $query1 = &db_query("SELECT id, title FROM sections"); my @sections = (); while (my $rows1 = $query1->fetchrow_hashref()) { my $sectionid = $rows1->{id}; my $query2 = &db_query("SELECT title FROM pages WHERE sectionid = $sectionid"); my @pages = (); while (my $rows2 = $query2->fetchrow_hashref()) { push @pages, $rows2; } push @sections, { pages => \@pages }; } $template->param(sections => \@sections);