function sub7(left, right, level, depth) {
$list = список прямых потомков (`left_branch` >= :left_key AND `right_branch` <= :right AND `level` = :level+1);
foreach($list as $item) {
echo "<li>{$item['name']}";
if (depth < 7) {
echo "<ul>";
sub7($item['left'], $item['right'], $item['level'], $depth+1);
echo "</ul>";
}
}
}
echo "Команда:<ul>";
sub7($current_user_left, $current_user_right, $current_user_level, 0);
echo "</ul>"
word_id | language | word
--------+----------+---------
1 | RU | почему
1 | FR | pourquoi
1 | EN | how
1 | EN | why so
1 | DE | warum