how can i convert this query to a larvel syntax to use pagenation :        $db = DB::connection()->getPdo();
                $query = "
                    SELECT 
                    c.id, sys_id, cam_name, description, brand, product, c.status, update_by, start_date, end_date,  
                    DATE_FORMAT(CONVERT_TZ(c.created_at, @@session.time_zone, '" . Common::utc_offset() . "'), '%Y-%m-%d %H:%i:%s') as created_at, 
                    DATE_FORMAT(CONVERT_TZ(c.updated_at, @@session.time_zone, '" . Common::utc_offset() . "'), '%Y-%m-%d %H:%i:%s') as updated_at, 
                    hashid, blm_field, inactive_period, is_testing, signature, camp_type,
                    SUM(IF(p.inter = 1 AND p.admin_res = 0, 1, 0)) as Bi_count
                    FROM camp c
                    LEFT JOIN pros p on c.id = p.camp_id   "
                ;
                if ($campaign_type != null) $query = $query . ' WHERE c.campaign_type = "' . $camp_type . '" ';
                $query = $query . ' GROUP BY c.id ';
    
                $excute= $db->prepare($query);

i am really new at laravel so m wondering if there is a way i can convert this query to laravel syntax to use `pagination()`