message: "SQLSTATE[HY000] [2002] php_network_getaddresses: getaddrinfo failed: Temporary failure in name resolution (SQL: select * from `users`...)"
Your DB_HOST environment variable is clearly wrong. You added the http:// URI Scheme to it. The http:// scheme is for identifying a http protocol, MySQL don't use it.
You should use only the hostname, without prefixes:
DB_HOST=localhost