You would be best working with the Wix option of using the external dataset.
https://support.wix.com/en/article/corvid-working-with-external-database-collections
https://www.wix.com/corvid/reference/external-database-collections.html
If you search the forum on this, you will find previous posts that could be helpful for you too.
https://www.wix.com/corvid/forum/community-discussion/sync-external-db-with-wix-collection
https://www.wix.com/corvid/forum/community-discussion/connect-database-from-mysql
https://www.wix.com/corvid/forum/community-discussion/sync-your-mysql-database-to-wix-finally-working-article
Please note that with the last link that Andreas is not connected with Wix anymore, so you can only read the post itself.