PHP数组转SQL

$array = array
        (
            53 => array('num' => 20,'name' => 'aaa'),
            10 => array('num' => 20,'name' => 'bbb')
        );

$sql =“插入数据（id，num，name）值('53','20','aaa'),('10','20','bbb') ";

如何将 $array 转换为('53','20','aaa'),('10','20','bbb') ?

Thanks

内爆（） https://www.php.net/implode可以帮助您做到这一点，尽管您需要循环并将其应用到每个单独的数组：

 $resultStrings = array();
 foreach ($array as $key => $values) {
    $subarrayString = "('$key','" . implode($values, "','") . "')";
    $resultStrings[] = $subarrayString;
 }
 
 $result = implode($resultStrings, ",");