function($query){
    exit(123);
    $query->andWhere(['team_status'=>self::STATUS_TEAM_APPROVED]);
}

SELECT id,  login FROM `user`
    WHERE team_id = (
	          SELECT team_id FROM `user`
                 WHERE id = 1 # ID участника группы
			 ) 
    AND team_status = 'active';