Please help to resolve Hierarchy Tree related issue

Hello,
I have these three hierarchy related tables in MYSQL.
— parent […]

Original post by shreya.p