xxxxxxxxxx
INSERT INTO dealer_service_rate (username, groupname, rate)
SELECT username, groupname, rate FROM sub_dealer_service_rate
WHERE username='rohaannet'
xxxxxxxxxx
INSERT INTO table_name(column_list)
SELECT
select_list
FROM
another_table
WHERE
condition;