When Installing python mysqlclient, ld: library not found for -lzstd Error Occurs

When installing mysqlclient

[pipenv.exceptions.InstallError]: ld: warning: directory not found for option '-L/usr/local/opt/openssl/lib/'
[pipenv.exceptions.InstallError]: ld: library not found for -lzstd
[pipenv.exceptions.InstallError]: clang: error: linker command failed with exit code 1 (use -v to see invocation)
[pipenv.exceptions.InstallError]: error: command 'clang' failed with exit status 1

If you encounter this error

brew install openssl

BREW_PREFIX=$(brew --prefix)
export LDFLAGS="-L${BREW_PREFIX}/lib -L${BREW_PREFIX}/opt/openssl/lib"
export CPPFLAGS="-I${BREW_PREFIX}/include -I${BREW_PREFIX}/opt/openssl/include"

https://stackoverflow.com/questions/67767255/error-when-install-mysqlclient-using-pip-to-macos-bigsur