How to pull grandchildren from database
I want to pull out menu items from MySQL.

    Main menu           id=1, parentid=0
    -Contact us         id=2, parentid=1
    -Music              id=3, parentid=1
     --Rock             id=8, parentid=3
     --Classic          id=9, parentid=3
    -Car                id=4, parentid=1
      --Toyota          id=5, parentid=4,
      --Ford            id=6, parentid=4,
      --Honda           id=7, parentid=4
    
    Other menu          id=10, parentid=0
    -Othermain          id=11, parentid=10
      --submenu         id=12, parentid=11

    etc.

I can pullout data from id=1 to 4 and display by "...where parentid=1" etc.
However this pulls out only the top level.

But I want to pullout all the data including submenu as well.

Could anyone tell me how to write a query in MySQL for this please?

Thanks in advance.
How to pull grandchildren from database
===

I want to pull out menu items from MySQL.

    Main menu           id=1, parentid=0
    -Contact us         id=2, parentid=1
    -Music              id=3, parentid=1
     --Rock             id=8, parentid=3
     --Classic          id=9, parentid=3
    -Car                id=4, parentid=1
      --Toyota          id=5, parentid=4,
      --Ford            id=6, parentid=4,
      --Honda           id=7, parentid=4
    
    Other menu          id=10, parentid=0
    -Othermain          id=11, parentid=10
      --submenu         id=12, parentid=11

    etc.

I can pullout data from id=1 to 4 and display by "...where parentid=1" etc.
However this pulls out only the top level.

But I want to pullout all the data including submenu as well.

Could anyone tell me how to write a query in MySQL for this please?

Thanks in advance.