code: private function getBundle($articleNumber, $customerGroupId)
      {
          try {
              $query = '
                  SELECT * FROM s_articles_bundles AS bundle 
                  LEFT JOIN s_articles_bundles_prices AS bundlePrice
                  ON bundle.id = bundlePrice.bundle_id
                  WHERE bundle.ordernumber = :articleNumber
                  AND bundlePrice.customer_group_id = :customerGroupId
              ';
  
              return $this->entityManager->getConnection()->fetchAssoc($query, [
                  ':articleNumber' => $articleNumber,
                  ':customerGroupId' => $customerGroupId,
              ]);
          } catch (Exception $exception) {
              return [];
          }
      }
docs: @param int $articleNumber
  @param int $customerGroupId
  
  @return array