In my case with Sequola 15.1
sudo CXXFLAGS="-I/opt/homebrew/opt/unixodbc/include/" LDFLAGS="-L/opt/homebrew/lib/" /Applications/MAMP/bin/php/php8.3.14/bin/pecl install sqlsrv pdo_sqlsrv