public function _BeforeGet() { $this->SQL->select('Ban.*')->select('iu.Name', '', 'InsertName')->join('User iu', 'Ban.InsertUserID = iu.UserID', 'left'); parent::_BeforeGet(); }