Ublaboo datagrid generování treeview

Zdravím všechny,
Snažím se vytvořit datagrid který vygeneruje treeview ale nějak jsem se zasekl na db.

Presenter kde generuji datagrid

    /**
     * @param $name
     * @throws \Ublaboo\DataGrid\Exception\DataGridColumnStatusException
     * @throws \Ublaboo\DataGrid\Exception\DataGridException
     */
    public function createComponentReasonGrid($name)
    {
        $grid = new DataGrid();
        $reasons = $this->settignsRepository->getReasonList();
        $this->addComponent($grid, $name);
        $grid->setPrimaryKey('reason_id');
        $grid->setDataSource($reasons);
        $grid->setTreeView([$this, 'getChildren'], 'has_children');
        $grid->setDefaultSort(['id' => 'ASC']);

        $grid->addColumnText('title', 'Název důvodu')
            ->setSortable()
            ->setFilterText();
        $grid->addColumnNumber('id', 'ID', 'reason_id')
            ->setFormat(0, '', '')
            ->setSortable()
            ->setFilterText();
        $grid->addColumnStatus('hidden', 'Stav')
            ->setAlign('center')
            ->addOption(0, 'Aktivní')
            ->setClass('btn-primary')
            ->endOption()
            ->addOption(1, 'Neaktivní')
            ->setClass('btn-success')
            ->endOption()
            ->onChange[] = [$this, 'categoriesStatusChange'];


        $grid->addAction('create', 'Nová kategorie', '')
            ->addParameters(['act' => 'new-sub',])
            ->setIcon('plus')
            ->setClass('btn btn-xs btn-default')
            ->setTitle('Nová kategorie');

        /**
         * Edit Action
         */
        $grid->addAction('edit', 'Editace', '')
            ->setIcon('edit')
            ->setTitle('Upravit detail kategorie')
            ->setClass('btn btn-xs btn-success');

        /**
         * Delete action
         */
        $grid->allowRowsAction('delete', function($item) {
            return !$this->settignsRepository->checkDeleteReason($item->reason_id);
        });


        $grid->addAction('delete', '', 'delete!')
            ->setIcon('trash')
            ->setTitle('Smazat')
            ->setClass('btn btn-xs btn-danger ajax')
            ->setConfirm('Opravdu chcete kategorii ?');

        $grid->onRender[] = function (\Ublaboo\DataGrid\DataGrid $grid) use ($reasons): void {
            $grid->setDataSource($reasons->getReasonList());
        };
    }

Db která má vrátit treeview

    public function getReasonList() {

        $join = $this->db->select('COUNT(reason_id) AS count, parent_reason_id')
            ->from(self::TABLE_REASON)
            ->groupBy('parent_reason_id');

        $fluent = $this->db
            ->select('c.*, c_b.count as has_children')
            ->from(self::TABLE_REASON, 'c')
            ->leftJoin($join, 'c_b')
            ->on('c_b.parent_reason_id = c.reason_id')
            ->where('c.parent_reason_id IS NULL');

        return $fluent;
    }

    public function getChildren($id) {
        $join = $this->db->select('COUNT(reason_id) AS count, parent_reason_id')
            ->from(self::TABLE_REASON)
            ->groupBy('parent_reason_id');

        $fluent = $this->db
            ->select('c.*, c_b.count as has_children')
            ->from(self::TABLE_REASON, 'c')
            ->leftJoin($join, 'c_b')
            ->on('c_b.parent_reason_id = c.reason_id')
            ->where('c.parent_reason_id = %i', $id);

        return $fluent;
    }

DB

DROP TABLE IF EXISTS `reason`;
CREATE TABLE `reason` (
  `reason_id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(100) COLLATE utf8_czech_ci NOT NULL,
  `order_no` int(11) NOT NULL,
  `hidden` tinyint(4) NOT NULL,
  `perent_reason_id` int(11) DEFAULT NULL,
  PRIMARY KEY (`reason_id`),
  KEY `perrent_reason_id` (`perent_reason_id`),
  CONSTRAINT `reason_ibfk_1` FOREIGN KEY (`perent_reason_id`) REFERENCES `reason` (`reason_id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci;


-- 2020-07-17 10:36:49

Chyba:

You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'GET REASON LIST ORDER BY `reason_id` ASC' at line 1

SELECT c.*, c_b.count as has_children
FROM reason c
LEFT JOIN (
SELECT COUNT(reason_id) AS count, parent_reason_id
FROM `reason`
GROUP BY `parent_reason_id`) c_b ON c_b.parent_reason_id = c.reason_id
WHERE c.parent_reason_id IS NULL GET REASON LIST
ORDER BY `reason_id` ASC

Tuto stejnou metodu již používám v jiné aplikaci a tam vše funguje ale na druhé to nechce jet.

Díky všem za pomoc

Editoval jAkErCZ (17. 7. 2020 12:38)