<?php

public function getDataSidebar($param)
{
    $result = array();

    $tm_mainmenu_query = $this->db
        ->select('DISTINCT(TM_MAINMENU.ID_MAINMENU),TM_MAINMENU.*')
        ->from('TM_MAINMENU')
        ->join('T_SUBMENU',"TM_MAINMENU.ID_MAINMENU=T_SUBMENU.ID_MAINMENU","left")
        ->join('TMUSER',"TMUSER.OTORITAS=T_SUBMENU.ADMIN","left");

    // $this->db->where('T_SUBMENU.ADMIN','1');
    $tmuser = $this->db->from('TMUSER')->where('USERID', $data['USERID'])->get()->row();
    if ($tmuser && $tmuser->OTORITAS == 'ADMIN')
    {
        $tm_mainmenu_query->where('T_SUBMENU.ADMIN', '1');
    }

    if ($tm_mainmenus = $tm_mainmenu_query->order_by("TM_MAINMENU.URUT_MAINMENU ASC")->get()->result_array())
    {
        foreach ($tm_mainmenus as $i => $tm_mainmenu)
        {
            $result[$i] = $tm_mainmenu;
            $result[$i]['SUBMENU'] = $this->getSubMenu($tm_mainmenu['ID_MAINMENU']);
        }
    }

    return $result;
}