2 method of query in IPTV

fail.php

<?php
$query = "SELECT SQL_CALC_FOUND_ROWS notifications.* FROM notifications WHERE";

        if (!empty($filters['subsystem_id'])) {
            $query .= " notifications.subsystem_id=:subsystem_id";
        }
        $stm = $this->db->prepare($query);
        $stm->execute([':subsystem_id' => $filters['subsystem_id']]);
        $data = [];
        while ($row = $stm->fetch(\PDO::FETCH_ASSOC)) {
            $data[] = $row;
        }
        return $data;        

success.php

<?php
$notifics = DB::table('notifications');
        if (!empty($filters['subsystem_id'])) {
            $notifics->where('subsystem_id',$filters['subsystem_id']);
        }
        return $notifics->get();