So after a lot of Googling I have found one thing that Github pages does not support anything for a dynamic site having a backend and database its just static.
While Heroku supports Node.js and SQL as backend
So if I deploy my React app on GitHub pages having all my axios Post links pointing to Heroku server where my node.js is deployed with MySQL database will it work ? will my website from GitHub pages able to communicate with node.js backend and retrieve data from database ? any help will be appreciated