Seemingly simple concept seems impossible in Strapi

I have a Category content type. A Category can have many Categories but belongs to only one parent Category. Its a good old fashioned run of the mill self referencing table. I have built these a million time in sql.

Category

  • Id
  • name
  • parentId ( points to a single parent category )
  • children ( points to many child categories )

I thought I had this set up correctly but I kept getting call stack errors when trying to add child or parent categories. I have searched Bing and Google search as well as watched a few YT videos about relations but I cannot find anything that explains how to build a self referencing one to many relation. Does anyone know of a blog or something that explains how to set this up in strapi?

This topic has been created from a Discord post (1231439429638557776) to give it more visibility.
It will be on Read-Only mode here.
Join the conversation on Discord

But this is not going to work with strapi transfer