Cho view record nếu record được assign cho group có chứa subordinate của user

function getQuery() {
		$currentUser = vglobal('current_user');
		$user_record = Users_Record_Model::getInstanceById($currentUser->id,"Users");
		$user_subordinates = array_keys ($user_record->getSubordinateUsers());
		$user_subordinates	= implode(	',', $user_subordinates	);
		$queryGenerator = $this->get('query_generator');
		$listQuery = $queryGenerator->getQuery();
 
		$listQuery	= str_replace(	"INNER JOIN vt_tmp_u$currentUser->id","INNER JOIN  (select distinct groupid as id from vtiger_users2group where userid in ($user_subordinates)
			union SELECT id from vt_tmp_u$currentUser->id)  as ", $listQuery);
		return $listQuery;
	}