siki

<?php
    $askepId    = 1;
    $askepSdkis = \DB::table('askep_sdki')
                    ->where('askep_id', $askepId)
                    ->pluck('askep_sdki_id');

    $pluckedSdki = \DB::table('askep_sdki')
                    ->where('askep_id', $askepId)
                    ->pluck('sdki_id');
    
    // list sdki
    $selectedSdki = \DB::table('askep_sdki')
                        ->join('sdki', 'sdki.sdki_id', 'askep_sdki.sdki_id')
                        ->where('askep_id', $askepId)
                        ->get();
    
    // list bd
    $selectedBd = \DB::table('askep_bd')
    ->join('bd', 'bd.bd_id', 'askep_bd.bd_id')
    ->whereIn('askep_sdki_id', $askepSdkis)
    ->get();


    // list dd
    $selectedDd = \DB::table('askep_dd')
    ->join('dd', 'dd.dd_id', 'askep_dd.dd_id')
    ->whereIn('askep_sdki_id', $askepSdkis)
    ->get();

    // list kat - subkat - siki
    $selectedSiki = \DB::table('askep_siki')
    ->join('siki', 'siki.siki_id', 'askep_siki.siki_id')
    ->whereIn('askep_sdki_id', $askepSdkis)
    ->pluck('siki_id');
    
    $katSiki = \DB::table('kat_siki')
    ->whereIn('sdki_id', $pluckedSdki)
    ->get()
    ->toArray();

    foreach($katSiki as $kat) {
        $kat['subkat'] = \DB::table('subkat_siki')
                ->where('kat_siki_id', $kat['kat_siki_id'])
                ->get()
                ->toArray();
        
        foreach($kat['subkat'] as $subkat) {
            $subkat['siki'] = \DB::table('siki')
                ->where('subkat_siki_id', $subkat['subkat_siki_id'])
                ->whereIn('siki_id', $selectedSiki)
                ->get()
                ->toArray();
        }
    }
?>