Migration of records to the table with different column names
The SQL would be like:

insert into tab1 (category_id, created_at, title, promo, content)
as
select 3, date_art, title_art, short_art, full_art
from   tab2


The ID column will get it's value during the insert.