The field you are search for is called ProjectWorkspaceInternalHRef it can for example be found in view MSP_EpmProject_UserView.
The following query should provide you with project name and corresponding URL:
SELECT [ProjectUID], [ProjectName], [ProjectWorkspaceInternalHRef]
FROM [ProjectServer_Reporting].[dbo].[MSP_EpmProject_UserView]