30 Days Of Python

Hi all Im struggling to find solution for this problem ...we are given this table and parent as 1....... I want to find it's all children and grand children..... Only one SQL is allowed ..in python program...