SurrealQL recursion

output.json

[
    {
        "id": "recursion:five",
        "links": [
            "recursion:four",
            "recursion:two"
        ],
        "resolved": [
            {
                "id": "recursion:four",
                "links": [
                    "recursion:two"
                ],
                "resolved": [
                    {
                        "id": "recursion:two",
                        "links": [
                            "recursion:one"
                        ],
                        "resolved": [
                            {
                                "id": "recursion:one",
                                "links": [],
                                "resolved": []
                            }
                        ]
                    }
                ]
            },
            {
                "id": "recursion:two",
                "links": [
                    "recursion:one"
                ],
                "resolved": [
                    {
                        "id": "recursion:one",
                        "links": [],
                        "resolved": []
                    }
                ]
            }
        ]
    },
    {
        "id": "recursion:four",
        "links": [
            "recursion:two"
        ],
        "resolved": [
            {
                "id": "recursion:two",
                "links": [
                    "recursion:one"
                ],
                "resolved": [
                    {
                        "id": "recursion:one",
                        "links": [],
                        "resolved": []
                    }
                ]
            }
        ]
    },
    {
        "id": "recursion:one",
        "links": [],
        "resolved": []
    },
    {
        "id": "recursion:three",
        "links": [
            "recursion:one",
            "recursion:two"
        ],
        "resolved": [
            {
                "id": "recursion:one",
                "links": [],
                "resolved": []
            },
            {
                "id": "recursion:two",
                "links": [
                    "recursion:one"
                ],
                "resolved": [
                    {
                        "id": "recursion:one",
                        "links": [],
                        "resolved": []
                    }
                ]
            }
        ]
    },
    {
        "id": "recursion:two",
        "links": [
            "recursion:one"
        ],
        "resolved": [
            {
                "id": "recursion:one",
                "links": [],
                "resolved": []
            }
        ]
    }
]

schema.sql

BEGIN;

DELETE recursion;

DEFINE TABLE recursion SCHEMAFULL;
DEFINE FIELD links ON recursion TYPE array<record<recursion>> VALUE $value OR $before OR [];
DEFINE FIELD links.* ON recursion TYPE record<recursion>;
DEFINE FIELD resolved ON recursion VALUE <future> { 
    RETURN SELECT * FROM (links);
};

CREATE recursion:one;
CREATE recursion:two SET links = [recursion:one];
CREATE recursion:three SET links = [recursion:one, recursion:two];
CREATE recursion:four SET links = [recursion:two];
CREATE recursion:five SET links = [recursion:four, recursion:two];

RETURN SELECT * FROM recursion;

COMMIT;