PHPize Online / SQLize Online  /  SQLtest Online

<?php function find_subs($mainCategory, $arr, $str = '') { if (array_key_exists($mainCategory['ID'], $arr)) { $current = $arr[$mainCategory['ID']]; unset($arr[$mainCategory['ID']]); foreach ($current as $item) { echo $str . $item['kategoriAD'] . PHP_EOL; if (array_key_exists($item['ID'], $arr)) { $str .= $item['kategoriAD'] . ' --> '; find_subs($item, $arr, $str); } } } } $query = $pdo->query("SELECT kategoriUST, urunler.* FROM urunler")->fetchAll(PDO::FETCH_ASSOC | PDO::FETCH_GROUP); $mainCategories = reset($query); unset($query[key($query)]); foreach ($mainCategories as $mainCategory) { $str = $mainCategory['kategoriAD'] . ' --> '; echo $mainCategory['kategoriAD'] . PHP_EOL; find_subs($mainCategory, $query, $str); }