public static function getBranchByPersonifyId($personify_branch) {
    $connection = \Drupal::service('database');
    /** @var \Drupal\Core\Database\Query\Select $query */
    $query = $connection->select('openy_campaign_mapping_branch', 'b');
    $query->condition('b.personify_branch', $personify_branch);
    $query->fields('b', ['branch']);
    $result = $query->execute()->fetchField();

    return $result;
  }