Apireservasi .php

<?php

defined('BASEPATH') OR exit('No direct script access allowed');

require APPPATH . '/libraries/REST_Controller.php';
use Restserver\Libraries\REST_Controller;

class ApiReservasi extends REST_Controller {

    function __construct($config = 'rest') {
        parent::__construct($config);
        $this->load->database();
    }


function index_get() {
$id = $this->get('id_user');
$where = '';

if($id != null){ $where = 'WHERE admin.id_user = "'.$id.'" '; }
$query = $this->db->
query('SELECT admin.id_user,admin.nama,admin.alamat,admin.nama_bank,admin.no_rek,service.nama_service,service.harga,pelayan.nama_pelayan
FROM admin LEFT JOIN pelayan ON (pelayan.id_admin=admin.id_user)
LEFT JOIN service ON (service.id_admin=admin.id_user) '.$where.'GROUP BY admin.id_user ORDER BY
admin.id_user ASC;');
$output = $query->result_array();
$this->response(array('data'=>$output));

}

}