[Improvement] kbcli support connect cluster create with cmpd new API

[JashBook]

Is your improvement request related to a problem? Please describe.

1. create cluster with cmpd

   apiVersion: apps.kubeblocks.io/v1alpha1
   kind: Cluster
   metadata:
   name: mysql-qszwbj
   namespace: default
   spec:
   componentSpecs:
   - componentDef: apecloud-mysql
   monitor: false
   name: mysql
   replicas: 1
   resources:
     limits:
       cpu: 100m
       memory: 512Mi
     requests:
       cpu: 100m
       memory: 512Mi
   serviceVersion: 8.0.30
   volumeClaimTemplates:
   - name: data
     spec:
       accessModes:
       - ReadWriteOnce
       resources:
         requests:
           storage: 1Gi
   terminationPolicy: WipeOut

2. see error

   kbcli cluster connect mysql-qszwbj
   error: fail to get the target engine type

   kbcli version
   Kubernetes: v1.26.3
   KubeBlocks: 0.9.0-beta.2
   kbcli: 0.9.0-beta.0

If this is a new function, please describe the motivation and goals.

Describe the solution you'd like A clear and concise description of what you want to happen.

Describe alternatives you've considered A clear and concise description of any alternative solutions or functions you've considered.

Additional context

[github-actions[bot]]

This issue has been marked as stale because it has been open for 30 days with no activity