        Cursor c = db.rawQuery(query, null);
        if (c != null) {
            c.moveToFirst();
            if (c.getCount() > 0) {
                list = new ArrayList<TeacherStudentItem>();
                while (!c.isAfterLast()) {
                    item = new TeacherStudentItem();
                    item.setId(c.getString(c.getColumnIndex("id")));
                    item.setFull_name(c.getString(c.getColumnIndex("full_name")));
                    item.setActive(c.getString(c.getColumnIndex("active")));
                    list.add(item);
                    c.moveToNext();
                }
            }
        }