Translate SQL to MongoDB query

Since the data of the department is already large enough to affect the query speed (190PB)
The product manager wants to transfer data to mongodb
At present, 3 collections have been imported into mongodb (a total of about 11 million transactions)
The following is the homework delivered to me by the manager: expand the bill of materials and present
The current SQL syntax is as follows:

SELECT *
FROM
  (SELECT  MB1.SEGMENT1  ASSEMBLY_NUM, MB2.SEGMENT1 COMPONENT_NUM, BC.COMPONENT_QUANTITY QTY,ASSEMBLY_ITEM_ID,BC.COMPONENT_ITEM_ID
   FROM  BOM_COMPONENTS_B  BC,
         BOM_STRUCTURES_B  BS,
         MTL_SYSTEM_ITEMS_B  MB1,
         MTL_SYSTEM_ITEMS_B  MB2
   WHERE  BS.ASSEMBLY_ITEM_ID = MB1.INVENTORY_ITEM_ID
   AND    BC.COMPONENT_ITEM_ID = MB2.INVENTORY_ITEM_ID
   AND    BC.BILL_SEQUENCE_ID = BS.BILL_SEQUENCE_ID
   AND    MB1.ORGANIZATION_ID = MB2.ORGANIZATION_ID
   AND    BS.ORGANIZATION_ID = MB2.ORGANIZATION_ID
   AND    (BC.DISABLE_DATE IS NULL OR BC.DISABLE_DATE > SYSDATE)
   AND    BS.ALTERNATE_BOM_DESIGNATOR IS NULL
   AND    MB1.ORGANIZATION_ID  = 112
  ) Q_BOM
START WITH   Q_BOM.ASSEMBLY_ITEM_ID = 5511458
CONNECT BY NOCYCLE PRIOR Q_BOM.COMPONENT_NUM = Q_BOM.ASSEMBLY_NUM;

and I execute it on Toad for Oracle and got the data grid:
enter image description here
My understanding is that Atlias, subquery, loop and other functions are not supported in mongodb
I think that due to the correlation between the data (upstream and downstream products and replacement item numbers)
So this method is not suitable, can someone help me with this ?
stackoverflow QA link