I am trying to migrate from oracle to mariadb. At the moment, we are facing an issue with the following oracle code.

   

    SELECT id,MK, pid,AFI FROM M A WHERE **LEVEL <= 2** START WITH pid = 1 CONNECT BY Pid = PRIOR id;


We have used recursive common expression table but we are unable to restrict the number of iterations to 2(LEVEL <= 2). We don't want to set the system variables like cte_max_recursion_depth. Please help us to solve the issue.