RizkiHerdaID

	public function index() {
      $all_categories = $this->categories->get_many_by(array('CHARACTER_LENGTH(kode_kategori) <= 2'));
      $categories = $this->get_level_0($all_categories);
	}
  
	public function get_level_0($parent) {
		$results = $this->kategori_m->get_many_by(array('status' => 1)); //capture the query data inside $results variable
		$menu = array();
		foreach ($parent as $list) {

RizkiHerdaID

SELECT * 
FROM tableA 
WHERE YEAR(columnName) = YEAR(CURRENT_DATE()) AND 
      MONTH(columnName) = MONTH(CURRENT_DATE());