SELECT dis_id as '업체명', id as '아이디', nick_name as '닉네임', `call` as '연락처', account_name as '이름', account_bank as '은행명', account_number as '계좌번호',  level as '레벨',
case when status = 1 then '정상' when status = 2 then '정지' when status = 3 then '탈퇴' when status = 11 then '대기' end as '상태',
(SELECT group_concat(m.content) FROM t_member_memo m WHERE m.member_idx=member.idx) AS '메모'
FROM member
where u_business = 1 and level < 9;