public static function getNotification($id) { $res = User::getNotificationSender($id); $res1 = DB::select("select distinct(rr.request_id), s.name as s_name, r.user_id as r_id, r.name as r_name\n , p.title as p_name,rr.request_id as id, rr.status, p.project_id as p_id\n from Request rr\n inner join User s on s.user_id = rr.sender_id\n inner join User r on r.user_id = rr.reciever_id\n inner join Project p on p.project_id = rr.project_id\n where rr.reciever_id=? and status=0", array($id)); return array_merge($res, $res1); }