SELECT device_id,SUBSTRING_INDEX(blog_url, '/', -1) AS user_name
FROM user_submit;