Custom Condition on Query
You can try use hook_query_TAG_alter

...
-&gt;addTag('my_module_birtday')

/**
 * Implements hook_query_TAG_alter().
 */
function my_module_query_my_module_birtday_alter(Drupal\Core\Database\Query\AlterableInterface $query) {
  $today = new DrupalDateTime();
  $today = $today-&gt;format("m-d");
  $query-&gt;addJoin('LEFT', 'user__field_birthday', 'field_birthday', 'field_birthday.entity_id = base_table.uid');
  $expression = "DATE_FORMAT(field_birthday.field_birthday_value,'%m-%d')";
  $args = [
    ':birthday'=&gt;$today
  ];
  $query-&gt;where($expression . '=:birthday', $args);

}