Mysql Laravel expert Need -- 9

Making a little website with my Laravel. Clicking on the home page makes the CPU very high. I need a Laravel Mysql Expert. SELECT * FROM posts WHERE status = 1 AND posts.worker_need> (SELECT COUNT (id) FROM prove WHERE job_id = [login to view URL] AND (status = 0 OR status = 1)) Here is the second condition that I am counting = (SELECT COUNT (id) FROM prove WHERE job_id = [login to view URL] AND (status = 0 OR status = 1)) With this query the whole server CPU becomes 100% just for this I wanted to know if there is any other way to do the count work where there will not be so much server load. SELECT * FROM posts WHERE status=1 AND posts.worker_need > (SELECT COUNT(id) FROM prove WHERE job_id=[login to view URL] AND (status = 0 OR status = 1))