mysql - How to query my tables to give data in such a format? -

i have developed structure represent hierarchical data in in db. have 3 tables relationship defined each one. enter image description here

how should query db data in such structure. enter image description here

query have data separate tables (gives me users product in table) list discusersconfs = newarraylist(ao.find(discuserconf.class, query.select()));

(gives me effects users in table)

list disceffectconfs = newarraylist(ao.find(disceffectconf.class, query.select()));

how can combine these queries data in way have shown relationship in below image. using active objects 1 of orm.

i this.

select table1 while fetching{      select again table 2 user = (user table1)           ...and on..   }

this problem , has more 1 solution. problem method each deeper level must give more table , add them manually code

Alconcel