my $child_sth = $prod_dbh->prepare_cached('select * from table2 where id = ?');
$child_sth->bind_param(1,$parent_data[0]);
$child_sth->execute();
my @child_data = $child_sth->fetchrow_array();
print Dumper(@child_data);