请问下这个子查询的sql怎么传入父查询SQL的条件

 select t.*,
       (select count(1)
          from (select connect_by_isleaf isleaf
                  from efficiency_selfassess_mould
                 start with id = t.id--t.id执行时说找不到
                connect by prior id = parent_id)
         where isleaf = 1)
  from efficiency_selfassess_mould t
 start with item_id = '0a6b5afe-5e05-40ba-b770-99a07c856b8c'
connect by prior id = parent_id

是oracle写的

如果你用的是mysql，你需要用程序来处理，如果你用的是oracle，你就需要用存储过程处理