The easiest way to load the MySQL Time Zone tables from your macOS tzdata is via this command:
mysql_tzinfo_to_sql /usr/share/zoneinfo | mysql -u root mysql
Once the file is imported, you'll need to restart MySQL or MariaDB:
# Determine if you have MySQL or MariaDB
brew list