...
my $insert_clr_sql = "insert into colorimage_info (pid,color) values (?,?)";
my $insert_clr_sth = $db->prepare( $insert_clr_sql );

for my $color ( @colors ) {
    $insert_clr_sth->execute( $npid, $color );
}
...