public static function getSubLinks($id) { $path = Folder::getPath($id); $folders = explode('/', $path); $links = []; $IN = ''; for ($i = 2, $c = count($folders); $i < $c; $i++) { $IN .= '"' . $folders[$i] . '",'; } $db_links = DB::select('SELECT folder_id, name FROM folders WHERE folder_id IN (' . substr($IN, 0, -1) . ')'); for ($i = 3, $c = count($folders); $i < $c; $i++) { foreach ($db_links as $link) { if ($folders[$i] == $link->folder_id) { array_push($links, $link); } } } return $links; }