php artisan migrate```コマンドでマイグレーションできない

解決したいこと

Laravel開発環境を構築しようと思い、php artisan migrateコマンドを実行しようとしてもエラーが出てしまい、DB接続しマイグレーションできない。

###ファイル構成
root/
├ app(Laravelプロジェクト)
├ docker/
│　└ Dockerfile
└ docker-compose.yaml

エラー内容

  Illuminate\Database\QueryException 

  SQLSTATE[HY000] [2002] php_network_getaddresses: getaddrinfo failed: Name or service not known (SQL: select * from information_schema.tables where table_schema = database and table_name = migrations and table_type = 'BASE TABLE')

  at vendor/laravel/framework/src/Illuminate/Database/Connection.php:712
    708▕         // If an exception occurs when attempting to run a query, we'll format the error
    709▕         // message to include the bindings with SQL, which will make this exception a
    710▕         // lot more helpful to the developer instead of just the database's errors.
    711▕         catch (Exception $e) {
  ➜ 712▕             throw new QueryException(
    713▕                 $query, $this->prepareBindings($bindings), $e
    714▕             );
    715▕         }
    716▕     }

      +36 vendor frames 
  37  artisan:37
      Illuminate\Foundation\Console\Kernel::handle(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput))

内容

このエラー自体は.envファイルでの環境変数の記述ミスによるものらしいので、確かめてみても間違ってなく現在詰んでる状態です。

各種ソースコード

docker
1version: '3'
2services:
3  app:
4    build: ./docker
5    ports:
6      - 80:80
7    volumes:
8      - ./app:/var/www/app
9    working_dir: /var/www/app
10  db:
11    platform: linux/x86_64
12    image: mysql:8.0
13    ports:
14      - 3306:3306
15    environment:
16      MYSQL_DATABASE: database
17      MYSQL_USER: user
18      MYSQL_PASSWORD: pass

Dockerfilefile
1FROM php:8.0-apache
2COPY --from=composer:latest /usr/bin/composer /usr/bin/composer
3RUN apt-get update && apt-get install -y \
4    git \
5    && docker-php-ext-install pdo_mysql
6    
7RUN sed -i 's!/var/www/html!/var/www/app/public!g' /etc/apache2/sites-available/000-default.conf

APP_NAME=Laravel
APP_ENV=local
APP_KEY=base64:2KXXtVvgGqOYcXbBP4nuRPKrDIEuLOtxcFbG/qbfGjc=
APP_DEBUG=true
APP_URL=http://localhost

LOG_CHANNEL=stack
LOG_DEPRECATIONS_CHANNEL=null
LOG_LEVEL=debug

DB_CONNECTION=mysql
DB_HOST=db
DB_PORT=3306
DB_DATABASE=database
DB_USERNAME=user
DB_PASSWORD=pass

BROADCAST_DRIVER=log
CACHE_DRIVER=file
FILESYSTEM_DRIVER=local
QUEUE_CONNECTION=sync
SESSION_DRIVER=file
SESSION_LIFETIME=120

MEMCACHED_HOST=127.0.0.1

REDIS_HOST=127.0.0.1
REDIS_PASSWORD=null
REDIS_PORT=6379

MAIL_MAILER=smtp
MAIL_HOST=mailhog
MAIL_PORT=1025
MAIL_USERNAME=null
MAIL_PASSWORD=null
MAIL_ENCRYPTION=null
MAIL_FROM_ADDRESS=null
MAIL_FROM_NAME="${APP_NAME}"

AWS_ACCESS_KEY_ID=
AWS_SECRET_ACCESS_KEY=
AWS_DEFAULT_REGION=us-east-1
AWS_BUCKET=
AWS_USE_PATH_STYLE_ENDPOINT=false

PUSHER_APP_ID=
PUSHER_APP_KEY=
PUSHER_APP_SECRET=
PUSHER_APP_CLUSTER=mt1

MIX_PUSHER_APP_KEY="${PUSHER_APP_KEY}"
MIX_PUSHER_APP_CLUSTER="${PUSHER_APP_CLUSTER}"