SQL codewith tbl as

(

select 13 as id, 10 as mgrid, 2 as ilevel, 100 as blance from dual

union all

select 41 as id, 13 as mgrid, 3 as ilevel, 100 as blance from dual

union all

select 42 as id, 13 as mgrid, 3 as ilevel, 100 as blance from dual

union all

select 43 as id, 13 as mgrid, 3 as ilevel, 100 as blance from dual

union all

select 14 as id, 10 as mgrid, 2 as ilevel, 100 as blance from dual

union all

select 44 as id, 14 as mgrid, 3 as ilevel, 100 as blance from dual

union all

select 45 as id, 14 as mgrid, 3 as ilevel, 100 as blance from dual

)

select id, sum(blance) as blance

from (select connect_by_root id as id, blance

from tbl

start with ilevel = 2

connect by prior id = mgrid) t

group by id;

ID BLANCE

---------- ----------

13 400

14 300