Tree view of a relationship database - Airtable


I have a data table with all of my unique mechanical parts

I have another data relationship table

how I can display the data in a way to see a parent/child tree

can a child become a parent so there is a construction chain between all its elements?

can someone help me?