how to build this list ?

Hello there

How to build this list ? I have no idea how to start, thanks for any help
!!

Table order :
orderid           main
------------------------------------------------
11111111    true
11111112    false
11111113    false
22222221    true
11111114    false
11111115    false
22222222    false
22222223    false

Table cylinder :
cylinderid  type  orderid
-------------------------------------------------
8888        01    11111111
8866        03    22222221
7986        01    11111111
8796        03    22222222
9876        03    22222222
8732        01    11111111
9876        03    11111112
7654        02    11111113
4532        04    11111115
4318        03    11111112
6653        02    11111113


The list I need :

11111111 (main order)           8888  01 (cylinderid, type)           7986  01 (cylinderid, type)           8732  01
(cylinderid,type)     11111112 (suborder)           9876  03 (cylinderid, type)           4318  03 (cylinderid, type)
 11111113 (suborder)           7654  02 (cylinderid, type)           6653  02 (cylinderid, type)     11111114
(suborder)    11111115 (suborder)
 
22222221 (main order)           8866  03 (cylinderid, type)     22222222 (suborder)           8796  03
(cylinderid,type)          9876  03 (cylinderid,typ)     22222223 (suborder)
 

__________________________________________________

PFISTER + PARTNER, SYSTEM - ENGINEERING AG
Juerg Rietmann
Grundstrasse 22a
6343 Rotkreuz
Switzerland

internet          :  www.pup.ch
phone       : +4141 790 4040
fax         : +4141 790 2545
mobile            : +4179 211 0315
__________________________________________________