stu.id AS id,        stu.sno AS sno,        stu.name AS name,        stu.subschool_id AS subschoolId,        sc.name AS subschoolName,        stu.sex AS sex,        CASE sex            WHEN '0' THEN '男'          WHEN '1' THEN '女'          WHEN '2' THEN '保密'          ELSE '未知'        END AS gender,        stu.grade AS grade,        stu.studying_status AS studyingStatus,        stu.last_signup_time AS lastSignupTime,        stu.contract_amount AS contractAmount,        IFNULL(stu.balance_no_jz,0) AS balanceNoJz,        IFNULL(stu.balance_jz,0) AS balanceJz,        IFNULL(stu.balance_no_jz,0)+IFNULL(stu.balance_jz,0) AS balance,        stu.referrer AS referrer    
        			SELECT DISTINCT		             FROM student stu        LEFT JOIN school sc ON stu.subschool_id = sc.id        						 		        WHERE stu.name LIKE #{keyword} or stu.mobile_phone LIKE #{keyword} AND stu.subschool_id = sc.id		                  ORDER BY stu.subschool_id DESC                                    limit ${offset}, ${limit}                                        limit ${limit}                      	

List
    
      queryStudent(@Param("keyword") String keyword,@Param("limit")  int limit,@Param("offset")  int offset);