Andrii, could you tell me more about the goal here? If it's just a quick one-time need, then I'd recommend exporting one table as a CSV, then importing to the other.
If it's an ongoing need, then at a high level I'd recommend setting up a webhook on the receiving table and an HTTP API integration on the other table to send its data to the webhook.