Opencart empty result set

category.php

<?php
class ModelCatalogCategory extends Model {
	public function getCategory($category_id) {
		$query = $this->db->query("SELECT DISTINCT * FROM " . DB_PREFIX . "category c LEFT JOIN " . DB_PREFIX . "category_description cd ON (c.category_id = cd.category_id) LEFT JOIN " . DB_PREFIX . "category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.category_id = '" . (int)$category_id . "' AND cd.language_id = '" . (int)$this->config->get('config_language_id') . "' AND c2s.store_id = '" . (int)$this->config->get('config_store_id') . "' AND c.status = '1'");

		return $query->row;
	}

	public function getCategories($parent_id = 0) {
		$query = $this->db->query("SELECT * FROM " . DB_PREFIX . "category c LEFT JOIN " . DB_PREFIX . "category_description cd ON (c.category_id = cd.category_id) LEFT JOIN " . DB_PREFIX . "category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '" . (int)$parent_id . "' AND cd.language_id = '" . (int)$this->config->get('config_language_id') . "' AND c2s.store_id = '" . (int)$this->config->get('config_store_id') . "'  AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)");

		return $query->rows;
	}

	public function getCategoryFilters($category_id) {
		$implode = array();

		$query = $this->db->query("SELECT filter_id FROM " . DB_PREFIX . "category_filter WHERE category_id = '" . (int)$category_id . "'");

		foreach ($query->rows as $result) {
			$implode[] = (int)$result['filter_id'];
		}

		$filter_group_data = array();

		if ($implode) {
			$filter_group_query = $this->db->query("SELECT DISTINCT f.filter_group_id, fgd.name, fg.sort_order FROM " . DB_PREFIX . "filter f LEFT JOIN " . DB_PREFIX . "filter_group fg ON (f.filter_group_id = fg.filter_group_id) LEFT JOIN " . DB_PREFIX . "filter_group_description fgd ON (fg.filter_group_id = fgd.filter_group_id) WHERE f.filter_id IN (" . implode(',', $implode) . ") AND fgd.language_id = '" . (int)$this->config->get('config_language_id') . "' GROUP BY f.filter_group_id ORDER BY fg.sort_order, LCASE(fgd.name)");

			foreach ($filter_group_query->rows as $filter_group) {
				$filter_data = array();

				$filter_query = $this->db->query("SELECT DISTINCT f.filter_id, fd.name FROM " . DB_PREFIX . "filter f LEFT JOIN " . DB_PREFIX . "filter_description fd ON (f.filter_id = fd.filter_id) WHERE f.filter_id IN (" . implode(',', $implode) . ") AND f.filter_group_id = '" . (int)$filter_group['filter_group_id'] . "' AND fd.language_id = '" . (int)$this->config->get('config_language_id') . "' ORDER BY f.sort_order, LCASE(fd.name)");

				foreach ($filter_query->rows as $filter) {
					$filter_data[] = array(
						'filter_id' => $filter['filter_id'],
						'name'      => $filter['name']
					);
				}

				if ($filter_data) {
					$filter_group_data[] = array(
						'filter_group_id' => $filter_group['filter_group_id'],
						'name'            => $filter_group['name'],
						'filter'          => $filter_data
					);
				}
			}
		}

		return $filter_group_data;
	}

	public function getCategoryLayoutId($category_id) {
		$query = $this->db->query("SELECT * FROM " . DB_PREFIX . "category_to_layout WHERE category_id = '" . (int)$category_id . "' AND store_id = '" . (int)$this->config->get('config_store_id') . "'");

		if ($query->num_rows) {
			return (int)$query->row['layout_id'];
		} else {
			return 0;
		}
	}

	public function getTotalCategoriesByCategoryId($parent_id = 0) {
		$query = $this->db->query("SELECT COUNT(*) AS total FROM " . DB_PREFIX . "category c LEFT JOIN " . DB_PREFIX . "category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '" . (int)$parent_id . "' AND c2s.store_id = '" . (int)$this->config->get('config_store_id') . "' AND c.status = '1'");

		return $query->row['total'];
	}
}

menu.php

<?php
class ControllerCommonMenu extends Controller {
	public function index() {
		$this->load->language('common/menu');

		// Menu
		$this->load->model('catalog/category');

		$this->load->model('catalog/product');

		$data['categories'] = array();
		//echo '<pre>'; var_dump($this->model_catalog_category->getCategories(169)); exit();

		$categories = $this->model_catalog_category->getCategories(0);

		foreach ($categories as $category) {
			if ($category['top']) {
				// Level 2
				$children_data = array();

				$children = $this->model_catalog_category->getCategories($category['category_id']);

				foreach ($children as $child) {
					// Level 3 
                                $children_data_3 = array();

                                $children_3 = $this->model_catalog_category->getCategories($child['category_id']);

                                foreach ($children_3 as $child_3) {

                                    $filter_data_3 = array(
                                        'filter_category_id'  => $child_3['category_id'],
                                        'filter_sub_category' => true
                                    );

                                    $children_data_3[] = array(
                                        'name'  => $child_3['name'] . ($this->config->get('config_product_count') ? ' (' . $this->model_catalog_product->getTotalProducts($filter_data_3) . ')' : ''),
                                        'href'  => $this->url->link('product/category', 'path=' . $child['category_id'] . '_' . $child_3['category_id'])
                                    );
                                }
                                //end of level 3

					$filter_data = array(
						'filter_category_id'  => $child['category_id'],
						'filter_sub_category' => true
					);

					$children_data[] = array(
						'thumb_menus' => HTTP_SERVER . 'image/' .$child['image'],
						'name'  => $child['name'] . ($this->config->get('config_product_count') ? ' (' . $this->model_catalog_product->getTotalProducts($filter_data) . ')' : ''),
						'href'  => $this->url->link('product/category', 'path=' . $category['category_id'] . '_' . $child['category_id']),
						'grand_childs' => $children_data_3//for level 3
					);
				}

				// Level 1
				$data['categories'][] = array(
					'name'     => $category['name'],
					'thumb_menu' => HTTP_SERVER . 'image/' . $category['image'],
					'children' => $children_data,
					'column'   => $category['column'] ? $category['column'] : 1,
					'href'     => $this->url->link('product/category', 'path=' . $category['category_id'])
				);
			}
		}

		return $this->load->view('common/menu', $data);
	}
}

menu.twig

<div id="desktop-menu" class="hidden-xs hidden-sm">
  {% if categories %}
  <div class="">
    <nav id="menu" class="navbar">
      <div class="navbar-header"><span id="category" class="visible-xs">{{ text_category }}</span>
        <button type="button" class="btn btn-navbar navbar-toggle" data-toggle="collapse"
          data-target=".navbar-ex1-collapse"><i class="fa fa-bars"></i></button>
      </div>
      <div class="collapse navbar-collapse navbar-ex1-collapse">
        <ul class="nav navbar-nav">
          {% for category in categories %}
          {% if category.children %}
          <li class="nav-item dropdown first-lvl-li">
            <a class="nav-link dropdown-toggle" href="#" data-toggle="dropdown">{{ category.name }}</a>
            <ul class="dropdown-menu">
              {% for children in category.children|batch(category.children|length / category.column|round(1, 'ceil')) %}
              {% for child in children %}
              {% if child.grand_childs %}
              <li class="second-lvl-li">
                <a href="{{ child.href }}" class="dropdown-item second-child">{{ child.name }}</a>
                <ul class="submenu dropdown-menu">
                  {% for grand_child in child.grand_childs %}
                  <li><a class="dropdown-item third-child" href="{{ grand_child.href }}"> {{grand_child.name}} </a>
                  </li>
                  {% endfor %}
                </ul>
              </li>
              {% else %}
              <li><a class="dropdown-item second-child" href="{{ child.href }}">{{ child.name }}</a></li>
              {% endif %}
              {% endfor %}
              {% endfor %}
              <li><a href="{{ category.href }}">{{ text_all }}&nbsp;{{ category.name }}</a></li>
            </ul>
          </li>
          {% else %}
          <li class="nav-item"><a class="nav-link" href="{{ category.href }}">{{ category.name }}</a></li>
          {% endif %}
          {% endfor %}
        </ul>
      </div>
    </nav>
  </div>
  {% endif %}
</div>

<div id="mobile-menu" class="hidden-md hidden-lg">
  {% if categories %}
  <nav id="menu" class="navbar">

    <div class="navbar-header">
      <!-- <span id="category" class="visible-xs">{{ text_category }}</span> -->
      <button type="button" class="btn btn-navbar" onclick="openNav()" data-toggle="collapse"
        data-target=".navbar-ex1-collapse"><i class="fa fa-bars"></i></button>
    </div>

    <div id="mySidenav" class="sidenav">
      <div class="close-nav">
        <span class="categories">Category</span>
        <a href="javascript:void(0)" class="closebtn" onclick="closeNav()"><i class="fa fa-close"></i></a>
      </div>
      <div class="collapse navbar-collapse navbar-ex1-collapse">
        <ul class="nav navbar-nav">
          {% for category in categories %}
          {% if category.children %}
          <li class="nav-item dropdown"><a href="{{ category.href }}" class="dropdown-toggle"
              data-toggle="dropdown">{{ category.name }}<i class="fa fa-angle-down pull-right"></i></a>
            <ul class="dropdown-menu">
              {% for children in category.children|batch(category.children|length / category.column|round(1, 'ceil')) %}
              {% for child in children %}
              {% if child.grand_childs %}
              <li class="second-lvl-li"><a class="dropdown-item" href="#">{{ child.name }}</a>
                <ul class="submenu dropdown-menu">
                  {% for grand_child in child.grand_childs %}
                  <li><a class="dropdown-item" href="{{ grand_child.href }}">{{grand_child.name}}</a></li>
                  {% endfor %}
                  <li><a href="{{ child.href }}">{{ text_all }}&nbsp;{{ child.name }}</a></li>
                </ul>
              </li>
              {% else %}
              <li><a class="dropdown-item" href="{{ child.href }}">{{ child.name }}</a></li>
              {% endif %}
              {% endfor %}
              {% endfor %}
              <li><a href="{{ category.href }}" class="see-all">{{ text_all }}&nbsp;{{ category.name }}</a></li>
            </ul>
          </li>
          {% else %}
          <li class="nav-item"><a href="{{ category.href }}">{{ category.name }}</a></li>
          {% endif %}
          {% endfor %}
        </ul>
      </div>
    </div>
  </nav>

  {% endif %}
</div>

<script type="text/javascript">
  $(document).on('click', '.dropdown-menu', function (e) {
    e.stopPropagation();
  });

  // make it as accordion for smaller screens
  if ($(window).width() < 992) {
    $('.second-lvl-li > a').click(function (e) {
      console.log(e);
      $(this).parent().css('margin-left', '0');
      e.preventDefault();
      if ($(this).next('.submenu').length) {
        $(this).next('.submenu').toggle();
      }
      $('.dropdown').on('hide.bs.dropdown', function () {
        $(this).find('.submenu').hide();
      })
    });
    $('.dropdown').on('show.bs.dropdown', function () {
      $(this).find('.dropdown-menu').css('margin-left', '0');
    });
  }
</script>