Following reference is an excellent example scenario describes how to securely connect a web app to a backend database over a fully private connection. The architectures ensure communication from the web app in Azure App Service and Azure SQL Database only traverses a virtual network.
Please have a look and see if it helps to resolve the issue
----------
--please don't forget to upvote
and Accept as answer
if the reply is helpful--