'', 'name' => '', ); public function getAccount($uniacid) { return $this->query->where('uniacid', $uniacid)->get(); } public function searchWithAccount() { return $this->query->from($this->tableName, 't') ->leftjoin('account', 'a') ->on(array('t.uniacid' => 'a.uniacid')); } }