I have the following datas in a db field text
TEXT
A-AB-A01
A-AB-A02
A-CD-A01
A-CD-A02
B-AB-A01
B-CD-B01
B-EF-C01
C-AB-A01
C-AB-A02
C-CD-E01
C-EF-E01
I need to get a ctree like this
A-AB-A01
---------A02
—CD-A01
---------A02
B-AB-A01
—CD-B01
—EF-C01
C-AB-A01
---------A02
C-CD-E01
----EF-E01
I don’t know how i can generate the data array out of one sql query.
Any help would be appreciated.