SQL script for menu structure
id   name     parent

1     x         null

2     y         1

3     z         null

4     a         3

5     b         2

-x

--y

---b

-z

--a

WHILE (SELECT MenuText FROM dbo.Table2 WHERE parent = NULL)
BEGIN
   SELECT MenuText FROM dbo.Table2 WHERE parent = ...
END