<?php
defined('BASEPATH') OR exit('No direct script access allowed');
class FamilyModel extends CI_Model{
  public function getFamily($id_user){
    $this->db->select('user2.id_user as id_user_family,user2.name as name_family,user2.email as email_family');
    $this->db->from('families');
    $this->db->join('user as user1','user1.id_user = families.id_user');
    $this->db->join('user as user2','user2.id_user = families.id_user_family');
    $this->db->where('user1.id_user',$id_user);
    $data = $this->db->get()->result();
    if(count($data)!=0){
      $response['message'] = 'Get Data Success';
      $response['error'] = false;
      $response['data'] = $data;
    }else{
      $response['message'] = 'Family Not Found';
      $response['error'] = true;
    }
    return $response;
  }
}