Query builder macro to replace one where clause with another

AppServiceProvider.php

/**
 * Replaces a where clause in a Builder with another where clause
 */
Builder::macro('replaceWhere', function (Builder $passedQuery, \Closure $howToGetValue) {
    $wheres = $passedQuery->wheres;

    $query = $passedQuery->cloneWithout([ 'wheres' ]);
    $bindings = [];

    foreach ($wheres as &$where) {
        $where = array_merge($where, $howToGetValue($where));
        $bindings[] = $where['values'] ?? $where['value'];
    }

    $query->wheres = $wheres;

    $query->setBindings(Arr::flatten($bindings), 'where');

    return $query;
});