Recursively retrieve relations of the model?

[latipovsharif]

Is there any way to get relations recursively? for example I've got the following struct:

type Tree struct {
	ID          int
	Parent   *Tree
	ParentID string
	Name     string
}

and I need to get all children of the object recursively. For now I'm doing like this

trees := []Tree{}
db.Model(&trees).Relation("Parent").Relation("Parent.Parent").Where("parent_id is null").Select()

it works if there is only two levels of depth but what if I don't know the depth of the relation?

[frederikhors]

@latipovsharif edit to write beauty code please.

[latipovsharif]

@frederikhors please look at this.

[vmihailenco]

Try to google "postgres tree" if you need a tree. I don't think you should be using ORM to build it.