how to store data in database from an external api

With a PHP database connection and a query?

Your question is too large to give you a precise answer.

You have to use the API, for example with http request functionality in Laravel.

https://laravel.com/docs/9.x/http-client#request-data

Once you have the data, you can save them to your database if you want.

https://laravel.com/docs/9.x/eloquent