带有外键约束的insert


INSERT INTO articles
  article, user_id
  select @article, user_id
    from users
    where user_name = @user