get multilevel child hierarchy in mysql query

enter image description here

I have a table like this.i want all child hierarchy by the MySQL query