class UserGroupDao extends BaseDao {

    public List<MemberView> findMemberPageList(Paging<UserGroup> paging) throws SQLException {
        String sql = "SELECT t1.group_id,t1.id,t1.user_id, t1.update_time, t2.user_no, t2.user_name, t2.user_email, t1.role," +
                "t1.opt_user,t2.user_real_name, t2.user_real_name as update_user_name " +
                "FROM user_group t1 " +
                "inner JOIN login_users t2 ON t1.user_id = t2.id " + appenMenberCondition(paging);
        return this.queryBySql(sql, MemberView.class);
    }

}