Linking tables with array of keys

I have a table of Users, which has an UserID column for unique id (String), and there is a field of "managerIds" which has a JSON array of UserIDs of the same table.

How can I specify that in the model, and then use it to both navigate from the user to her/his manager(s) and back from the manager to all their direct-reports? And also how that can be used in queries?

Hi @diegopamio
Metabase currently doesn't handle JSON/array - there are multiple issues open:
https://github.com/metabase/metabase/issues?q=is%3Aissue+is%3Aopen+array+in%3Atitle
Upvote the issues you're interested in by clicking :+1: on the first post of each issue.