Bagaimana caranya INSERT menggunakan INNER JOIN

contoh kek gini <pre> INSERT INTO user (id, name, username, opted_in) SELECT id, name, username, opted_in FROM user LEFT JOIN user_permission AS userPerm ON user.id = userPerm.user_id </pre> coba main ke mari <a href=' https://stackoverflow.com/questions/12073513/insert-using-left-join-and-inner-join '> https://stackoverflow.com/questions/12073513/insert-using-left-join-and-inner-join </a>