Export hierarchy tree in a specific way

I need a big help.

I have two tables (SubCells and Codes)

and

Visually it looks like this (We can count an order)

And i need to get this final result (with SQL or even a C#)

How can i do that ? I think i have to add Order column to my SubCells table, but how can i iterate Codes and get groups and codegroups information ? I prepared test environment and i will glad for all help.

http://sqlfiddle.com/#!3/438a6

Thank you