select messageId,parent
from messages
start with messageId = 1
connect by prior messageId = parent