self refrenced parent child relationship

[amirhossein828]

I have problem implementing self refrenced parent child relationship schema. it keeps returning the child as a parent.
(I want to have access to the parent of the employee in the search response)

Is there any example of self refrenced parent child relationship?

for example below would not work

"tables": [
{
"source": "employees",
"target": "employees_index",
"columns": [
"id",
"name",
"manager_id"
],
"children": [
{
"table": "employees",
"foreign_key": {
"child": ["manager_id"],
"parent": ["id"]
}
}
]
}
]