WITH RECURSIVE Hier(iID, iPK) AS
   (SELECT p.iID, p.iID AS iPK FROM mItems p WHERE p.iID IN (SELECT ID
         FROM gttItemsSelected
         WHERE TRIM(JobID) = ?{vp_JobID})
   UNION ALL
   SELECT H.iID, p2.iID AS iPK FROM mItems p2
   JOIN Hier H on p2.iPID = H.iPK) 
SELECT ...
      JOIN Hier
         ON sBOMIItem.iItemID = Hier.iID
...