Multi - level BOM - building model

Hi Anonymous,

Thanks for weighing in.

I try to explain everything in the simplest way.
First text, then specific example.

• Column ID from mrp_bom are the final BOM number (every BOM)
• Column ID from mrp_bom_line are BOM line number (components).
  Every bom line has his product_id.
  Every bom line has his parent_product_tmpl_id.
• Column ID from product ID are item number.
  Every item has his product_tmpl_id .

Look at the example below, I hope this will help to better understand my problem.
This is the product: 1-2-0431-0231, bom line id: 49891.

This is the first-level component 241192. 

His product template is 8562. 

His parent product template is 9046. (1 level above, in this case, the main product)

(This component is broken down into the next 2 levels)

The next level is the second-level component with the parent product template 8562.

One of these second-level component breaks down into the third - level with the parent product template 8653.

This is the final level.

My goal is to create a table, which will look like below.

How to achieve this?