select device_id,substring_index(blog_url,'/',-1) as user_name
from user_submit;