How to write a db table that includes other db rows?

Question

MySQL

Kind
I understand with a DB on the sly, here there was a task. How to draw up such a table, for example, there is a car wheel, and there is also what it consists of: rubber, camera, etc. What I want: I fill in the rows of elements in the database into the database, and then I collect a new element from these elements, i.e. like a wheel, first all its elements, then I create a line where I indicate which and how many elements are needed and call it "wheel". But at the same time, it should be clear what it consists of, i.e. links to other elements that you can also click on and see what they consist of. Phew, I hope I wrote clearly, thanks for the answers

Answer 1

Relations (Foreign Keys) between tables are necessary to you.

Answer 2

Make a query from several tables with comparison by index.