SELECT device_id,SUBSTRING_INDEX(blog_url,"/",-1) user_name
FROM user_submit