Sub Query Laravel 5.8

How to convert my SQL Query to Query Builder in Laravel 5.8 ? This is my Query :

SELECT 
  COUNT(id) AS DATA 
FROM 
  (
    SELECT 
      id, 
      (
        SELECT 
          COUNT(id_item) 
        FROM 
          project_item_deliveryorder 
        WHERE 
          id_item = project_item.id
      ) AS EXIST 
    FROM 
      project_item 
    WHERE 
      id_project_master = 1
  ) TBL_EXIST 
WHERE 
  TBL_EXIST.EXIST = 0;

Thank you for helping me :)

from Newest questions tagged laravel-5 - Stack Overflow https://ift.tt/2Tw9kim
via IFTTT