How to fix error Base table or view not found: 1146 Table laravel relationship table?

It seems Laravel is trying to use category_posts table (because of the many-to-many relationship).

But you don't have this table, because you've created category_post table. Change the name of the table to category_posts.