I went to the home page for Creative Cloud and I could not find Dreamweaver anywhere... I had to dig deep to find it and I'm wondering if Adobe is about to abandon another of it's Macromedia purchases??
Don't want to pay for a year of something that is EOL.
Also I notice that the CC installer is not updated for MacOS Catalina and will not work in it.
The official word is DW is in active production with no plan to end the program. Adobe has a "roadmap blog" where they've posted their plan, albeit a bit lackluster, for DW's future. Unfortunately, most "new" features recently, (and those that are planned in the near-term) have been re-introductions of features lost when the code view switched to Brackets, along with a batch of dubious Live View Editor updates.
"I could not find Dreamweaver"
I don't know why you couldn't find it. A Google search for Dreamweaver reveals this as the topmost search result.
Creative Cloud includes about 31 products and services. If you sort by Web & UX, you'll see it.
DW never dropped support for PHP & MySQL. I use those technologies all the time. But Adobe removed the deprecated server behaviors for which there are commercial replacements at WebAssist and DMX Zone. Or you could build your web app with Wappler.