How to fetch website login data into node red?

General
2

You could allow remote access to your database and query it directly.
Or
You could query a php script with a http request similar to this post MQTT data to a mySQL to display data on public website - #12 by astrojav Except using a select query and returning the data in the http response.