SELECT *,CONCAT('*',SUBSTR(u.member_id, 1,1),'**') as member_ids from user as u INNER ma_member AS m ON m.member_id=u.member_id